Hello Geeks and welcome to the Day 78 of the long series of One DMV a day. In this series of blogs I will be exploring and explaining the most useful DMV s in SQL Server. As we go ahead in this series we will also talk about the usage, linking between DMV s and some scenarios where these DMV s will be helpful while you are using SQL Server. For the complete list in the series please click here.

Till yesterday I have talked about various most useful DMV s. In today and tomorrow’s posts I will consolidate the most useful DMV queries I used in this series for a quick reference. BTW if you want to see how I look while I blog…

Consolidated DMV Scripts-Part 1

To check Index fragmentation: know more…

Using sys.dm_db_index_usage_stats: know more…

Checking Missing Indexes: know more…

Checking Operational Stats: know more…

 

IO Related DMVs:

Checking IO pending requests: know more…

Check IO issues files relating to IO requests: know more… 

 

TempDB Related DMVs:

File space usage details: know more…

Session space usage: know more…

Task space usage: know more…

 

OS related DMVs:

OS tasks: know more…

OS workers: know more…

OS threads: know more…

OS Schedulers: know more…

OS wait stats: know more…

Waiting tasks: know more…

 

Memory related DMVs:

OS process memory: know more…

OS memory clerks: know more…

OS memory objects: know more…

OS memory pools: know more…

Memory cache counters: know more…

Memory cache entries: know more…

Memory cache hash tables: know more…

Memory brokers: know more…

Memory cache clock hands: know more…

OS buffer descriptors: know more…

Rest of the DMV s will be continued tomorrow.

Happy Learning,
Manu

Like us on FaceBook | Join the fastest growing SQL Server group on FaceBook |
Follow me on Twitter | Follow me on FaceBook