Hello Geeks and welcome to the Day 79 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.

Yesterday we have seen the consolidated DMV scripts – part 1. Today I will cover the 2nd part of the consolidated scripts.

Execution related DMV s:

Exec connections: know more…

Exec Session: know more…

Check blocking using exec requests: know more…

Check running statement: know more…

Check query plan: know more…

Check text query plan: know more…

Collecting procedure stats: know more…

Exec query stats: know more…

Exec trigger stats: know more…

Cursor details: know more…

Background job queue: know more…

Background job queue stats: know more…

Exec cached plans: know more…

Exec plan attributes: know more…

Exec plan dependent objects: know more…

Exec query memory grants: know more…

Exec query resource semaphores: know more…

Exec describe first result set: know more…

 

Transaction related DMV s:

Tran locks: know more…

Tran database transactions: know more…

Tran session transactions: know more…

Tran active transactions: know more…

Tran current transactions: know more…

Tran version store: know more…

Tran top version store generators: know more…

Rest of them 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