|
Common Language Runtime
[1799]
Last Modified:
Apr 1, 2008 4:13 PM
These DMV's are useful for understanding and troubleshooting CLR objects executing within SQL Server.
|
|
|
|
Database
[1798]
Last Modified:
Apr 1, 2008 4:08 PM
These DMV's provide statistics which can be pulled from tempdb.
|
|
|
|
Transaction
[1797]
Last Modified:
May 13, 2009 4:25 PM
These DMV's provide information on database transactions
|
|
|
|
Execution Thread
[1796]
Last Modified:
Apr 1, 2008 3:50 PM
These DMVs and functions show what activity is executing on the server. The DMV sys.dm_exec_query_transformation_stats is used internally by SQL Server 2005.
|
|
|
|
SQL Server OS
[1795]
Last Modified:
Apr 1, 2008 2:34 PM
The following is a catalog of SQL Server Operating System related dynamic management views.
DMV's available in the SQL Server 2008 release - indicated by (*).
|
|
|
|
Security
[1794]
Last Modified:
Apr 1, 2008 2:33 PM
The DMV's in this section provide security related information and contains seven (7)
DMV's available in the SQL Server 2008 release - indicated by (*).
|
|
|
|
Index
[1793]
Last Modified:
Apr 1, 2008 11:59 AM
These DMV's provide index statistics and details (operational, physical, usage and missing).
|
|
|
|
I/O
[1792]
Last Modified:
Apr 1, 2008 11:59 AM
These DMV's provide I/O statistics.
|
|
|
|
Object
[1791]
Last Modified:
Apr 1, 2008 2:35 PM
The Object Related DMV's are available in SQL Server 2008. The DMVs in this section help you keep track of objects that are referenced by other objects in their definition, such as triggers, stored procedures, and functions.
All of these DMV's are available in the SQL Server 2008 release
|
|
|
|
Resource Governor
[1783]
Last Modified:
Apr 1, 2008 2:35 PM
DMV's related to the SQL Server 2008 Resource Governor.
All of these DMV's are available in the SQL Server 2008 release
|
|
|
|
SQL Server Extended Events
[1782]
Last Modified:
Apr 1, 2008 2:36 PM
SQL Server 2008 introduces the concept of "extended events", a general event-handling system that can correlate data from SQL Server, the OS, and applications using Event Tracing for Windows.
All of these DMV's are available in the SQL Server 2008 release.
|
|
