You are a database administrator for AIOTestKing.com. The SQL 2005 Server computer has been in operation for more than one month. This past week, query performance problems have led you to investigate locking contention. The sys.dm_os_wait_stats dynamic management view (DMV) is showing a high value in the max_wait_time_ms column.
You need to find out if this value is a factor in the current performance problems. You also must minimize the impact on database users. What should you do?
A.
Reset the statistics in the dynamic management view (DMV).
B.
Restart the SQL Server computer.
C.
Execute the UPDATE STATISTICS command.
D.
Restart the SQL Server Service.