question

Therealist avatar image
Therealist asked

What are the most often used DMVs ?

Hi I would like to know Most often used DMVs or Imp Dmvs that a Dba must be familiar with ?
dmv
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

This site functions according to votes. For all helpful answers below, show this by clicking on the thumbs up next to those answers. If any one answer lead to a solution, indicate this by clicking on the check mark next to that answer.
0 Likes 0 ·
CirqueDeSQLeil avatar image
CirqueDeSQLeil answered
The list is pretty big. This sounds more like an interview question than anything. I use a lot of the following: - sys.dm_xe_objects - sys.dm_xe_object_columns - sys.dm_xe_sessions - sys.dm_os_wait_stats - sys.dm_os_performance_counters
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image
Grant Fritchey answered
I'd suggest getting a copy of "Performance Tuning with SQL Server Dynamic Management Views" by Louis Davidson and Tim Ford. That will give you a good functional foundation on DMVs.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.