Dynamic Management View
Brief Summary
Total 12 categories
Few Useful DMVs
- Introduced in 2005
- They are system views
- Basically they are very useful to DBAs to get database / server level information in a most simplest and fastest way
- Really helpful in monitoring for DBAs
- Will be prefixed with dm_
- Will be part of sys schema
Total 12 categories
- DB Related
- CLR Related
- Full Text Search Related
- Transaction Related
- Index Related
- OS Related
- Replication Related
- DB Mirroring Related
- Execution Related
- I/O Related
- Query Notification Related
- Service Brocker Related
Few Useful DMVs
- sys.dm_db_index_physical_stats
- sys.dm_os_performance_counters
- sys.dm_exec_query_stats