Microsoft
70-432 · Question #114
You are mastering the company database, Users complaints that the SQL Server 2008 application is running slowly. You should check the information of the CPU utilization, disk utilization, and memory…
The correct answer is A. You should check the proper dynamic management views (DMVs). See the full explanation below for the reasoning.
Question
You are mastering the company database, Users complaints that the SQL Server 2008 application is running slowly. You should check the information of the CPU utilization, disk utilization, and memory utilization. The network should be considered. The detailed information should be checked for the proper example of SQL Server2008. Which is the correct answer?
Options
- AYou should check the proper dynamic management views (DMVs).
- BIn the databases, you should check the distribution of the statistics which are hosted
- CYou should check a statistics update commands the output.
- DYou should check the recovery model of the master database.
How the community answered
(64 responses)- A78% (50)
- B11% (7)
- C8% (5)
- D3% (2)
Community Discussion
No community discussion yet for this question.