You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment. In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005.You work as the administrator of a SQL Server 2005 computer, and the computer is called SQL01. The users complain the slow response of all client applications which connect to SQL01. You find that the CPU and memory utilization of SQL01 is low. In addition, the disk activity is low. The cause of the performance problem should be identified. Which action should be performed?()
- ASystem Monitor should be utilized to have SQL1s cache hit ratio examined.
- BThe sys.dm_db_index_physical_stats dynamic management function (DMF) should be examined.
- CThe sys.dm_db_partition_stats dynamic management view (DMV) should be examined.
- DTask Manager should be utilized to have utilization of SQL1s network adapter examined.