|
|
Dynamic Management Views with MSSQL
- Microsoft SQL Server keeps track of it's status with many Dynamic Management Views.
- These dynamic management views, replace a mish-mash of tools such as Profiler trace, perfmon, dbcc, pssdiag... These tools are still available in SQL Server 2005. But the Dynamic Management Views are easier and simpler to use.
- These views are reset when you restart SQL Server.
Applies to:
- Microsoft SQL Server 2005
- Microsoft SQL Server 2008
Dynamic Management Views
| Name prefix | Category | Description |
|---|
| dm_broker | service broker | service broker statistics |
| dm_clr | clr | common runtime language |
| dm_db | database | databases and database objects |
| dm_exec | execution | Execution of user code |
| dm_fts | full text | full text search information |
| dm_io | IO | input/output for network disks |
| dm_os | operating system | OS such as memory, locks... |
| dm_qn | query notification | active query notification subscription |
| dm_repl | replication | replication: articles, publications, transaction |
| dm_tran | transactions | transactions & isolation-levels |
|
|
