You are a database administrator for AIOTestKing.com. Users report that the performance of a SQL Server 2005 application seems slow. You verify that the SQL Server computers CPU utilization, disk utilization, and memory utilization are normal. You also verify that the network is operating normally. You need to examine more detailed performance information for the appropriate instance of SQL Server 2005. What should you do?
A.
Examine the distribution of the statistics in the databases that are hosted by the instance.
B.
Examine the recovery model of the tempdb database.
C.
Examine the appropriate dynamic management views (DMVs).
D.
Examine the output of a statistics update command.
Explanation:
Dynamic management views and functions return server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance.