Dynamic Management View Categories

Thinking today about a new area to cover on this site and I thought dynamic management views (or DMVs) was a good area to cover next.  I was looking at some documentation today for some DMVs and I realized that there is an easy way to think about them and their function.

  • sys.dm_exec_*  These provide information about sessions, connections, query executions and requests.
  • sys.dm_os_*  These provide information on OS related information
  • sys.dm_io_*  These provide input/output process information
  • sys.dm_tran_*  These provide transaction information
  • sys.dm_db_*  These provide database information

Enjoy and stay tune for more DMV information.

About SQLGator

Microsoft Data Platform MVP, Florida Gator, Star Wars fanatic and is there anything else...oh yeah PS4! I am a geek and SQL Server Business Intelligence Consultant, there are other technologies greater than these? Not so fast my friend! I also love to travel to new and exotic places.

Posted on March 18, 2013, in Scripting and tagged . Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: