Saturday, January 1, 2011

Dynamic Management View

Brief Summary

  • 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

No comments:

Post a Comment