YOU’RE THE DBA FOR A SALES AND MARKETING ORGANIZATION WHO HAVE A HI...

1. You’re the DBA for a sales and marketing organization who have a high rate

of data change (lots of INSERTS and DELETES). Over the past few weeks

the SQL server has gradually become slower. Which DMV could help identify

the cause?

A. Sys.dm_os_schedulers

B. Sys.dm_os_slow_tasks

C. Sys.dm_db_index_physical_stats

D. Sys.dm_exec_requests

The correct answer is C. Since there’s a high data churn, it’s possible that

index fragmentation is the cause; the index physical stats will confirm whether

this is the case. Problems with the SQLOS schedulers are unlikely to get

progressively worse. The DMV in Answer B does not exist. The DMV in

Answer D shows currently executing tasks and will be less useful when

investigating gradual server slowdown.