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.
Bạn đang xem 1. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P162 PPTX