Microsoft
70-450 · Question #117
You administer a SQL Server 2008 instance. The instance contains a large mission-critical database that experiences a high volume of DML activity. Users report that the applications that connect to…
The correct answer is C. Use the System Monitor tool. See the full explanation below for the reasoning.
Question
You administer a SQL Server 2008 instance. The instance contains a large mission-critical database that experiences a high volume of DML activity. Users report that the applications that connect to the database have a slow response time. You need to design a monitoring process that collects the following information:
What should you do?
Options
- AUse dynamic management views.
- BUse SQL Server Profiler.
- CUse the System Monitor tool.
- DUse Database Engine Tuning Advisor.
How the community answered
(31 responses)- A3% (1)
- B10% (3)
- C81% (25)
- D6% (2)
Community Discussion
No community discussion yet for this question.