What are Dynamic Management Functions (DMF) and Views (DMV) in SQL Server 2005/2008 ?
+1
A:
Dynamic Management Views and Functions (Transact-SQL) documentation:
Dynamic management views and functions return server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance.
Dynamic management views and functions return internal, implementation-specific state data. Their schemas and the data they return may change in future releases of SQL Server. Therefore, dynamic management views and functions in future releases may not be compatible with the dynamic management views and functions in this release. For example, in future releases of SQL Server, Microsoft may augment the definition of any dynamic management view by adding columns to the end of the column list. We recommend against using the syntax SELECT * FROM dynamic_management_view_name in production code because the number of columns returned might change and break your application.
The link includes more information, including a breakdown of the views & functions along with more specific information...
OMG Ponies
2010-08-28 19:50:04
+1 RTFM - Read the Fabulous Manual (or online documentation) :-)
marc_s
2010-08-28 20:51:47
A:
Introduced in SQL Server 2005 they provide a consistent way to look at the internals of SQL Server instances which previously required a fair bit of hacks. They provide the administrator about the various state of the SQL Server instances - for example sessions, memory etc.
no_one
2010-08-28 19:54:43