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 ?
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.
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
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.
16 People are following this question.
