Dynamic Management Function (DMF)

Eintrag zuletzt aktualisiert am: 17.10.2017

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

Beispiel

select * from sys.dmdb_log_info(DBID())

Weitere DMF

dmcryptographic_provideralgorithms
dmcryptographic_providerkeys
dmcryptographic_providersessions
dmdb_database_pageallocations
dmdb_incremental_statsproperties
dmdb_index_operationalstats
dmdb_index_physicalstats
dmdb_loginfo
dmdb_logstats
dmdb_missing_indexcolumns
dmdb_objects_disabled_on_compatibility_levelchange
dmdb_statshistogram
dmdb_statsproperties
dmdb_stats_propertiesinternal
dmexec_cached_plan_dependentobjects
dmexeccursors
dmexec_describe_first_resultset
dmexec_describe_first_result_set_forobject
dmexec_inputbuffer
dmexec_planattributes
dmexec_queryplan
dmexec_query_statisticsxml
dmexec_sqltext
dmexec_text_queryplan
dmexec_xmlhandles
dmfts_indexkeywords
dmfts_index_keywords_bydocument
dmfts_index_keywords_byproperty
dmfts_index_keywords_position_bydocument
dmftsparser
dmio_virtual_filestats
dmlogconsumercachebufferrefs
dmlogconsumerprivatecachebuffers
dmlogpoolconsumers
dmlogpoolsharedcachebuffers
dmlogpoolmgrfreepools
dmlogpoolmgrrespoolsize
dmlogpoolmgrstats
dmos_enumeratefilesystem
dmos_fileexists
dmos_volumestats
dmsql_referencedentities
dmsql_referencingentities

Liste aller DMF

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