Sie sind hier: Startseite | Wissen
Werbung
Begriff Dynamic Management Function
Abkürzung DMF
Eintrag zuletzt aktualisiert am 17.10.2017

 Zur Stichwortliste unseres Lexikons

Was ist Dynamic Management Function?

Eine Dynamic Management Function (DMF) liefert Informationen über den Zustand des Microsoft SQL Server-Datenbankservers in Form einer Function.

Beispiel

select * from sys.dm_db_log_info(DB_ID())

Weitere DMF

dm_cryptographic_provider_algorithms
dm_cryptographic_provider_keys
dm_cryptographic_provider_sessions
dm_db_database_page_allocations
dm_db_incremental_stats_properties
dm_db_index_operational_stats
dm_db_index_physical_stats
dm_db_log_info
dm_db_log_stats
dm_db_missing_index_columns
dm_db_objects_disabled_on_compatibility_level_change
dm_db_stats_histogram
dm_db_stats_properties
dm_db_stats_properties_internal
dm_exec_cached_plan_dependent_objects
dm_exec_cursors
dm_exec_describe_first_result_set
dm_exec_describe_first_result_set_for_object
dm_exec_input_buffer
dm_exec_plan_attributes
dm_exec_query_plan
dm_exec_query_statistics_xml
dm_exec_sql_text
dm_exec_text_query_plan
dm_exec_xml_handles
dm_fts_index_keywords
dm_fts_index_keywords_by_document
dm_fts_index_keywords_by_property
dm_fts_index_keywords_position_by_document
dm_fts_parser
dm_io_virtual_file_stats
dm_logconsumer_cachebufferrefs
dm_logconsumer_privatecachebuffers
dm_logpool_consumers
dm_logpool_sharedcachebuffers
dm_logpoolmgr_freepools
dm_logpoolmgr_respoolsize
dm_logpoolmgr_stats
dm_os_enumerate_filesystem
dm_os_file_exists
dm_os_volume_stats
dm_sql_referenced_entities
dm_sql_referencing_entities

Liste aller DMF

SELECT name, type, type_desc
FROM sys.system_objects
WHERE name LIKE 'dm_%' and type_desc like '%function%'
ORDER BY name

Querverweise zu anderen Begriffen im Lexikon

SQL
Datenbank

Beratung & Support:

Schulungen zu diesem Thema:

 Anfrage für eine individuelle Schulung zum Thema Dynamic Management Function  Gesamter Schulungsthemenkatalog