Microsoft
70-450 · Question #65
70-450 Question #65: Real Exam Question with Answer & Explanation
Sign in or unlock 70-450 to reveal the answer and full explanation for question #65. The question stem and answer options stay visible for context.
Question
You are a professional level SQL Sever 2008 Database Administrator. After a regular test, you find that performance degradation is experienced by an instance for the three reasons: Excessive CPU usage, Server processes paging and Deadlocks A monitoring solution should be implemented to provide data, monitor and troubleshoot performance issues and detailed deadlock information should be contained in the provided data. You should utilize the least amount of administrative effort to finish the task. Which tool will you utilize to finish the task?
Options
- ATo finish the task, you should utilize Resource Governor.
- BTo finish the task, you should utilize Database Engine Tuning Advisor.
- CTo finish the task, you should utilize Extended Events.
- DTo finish the task, you should utilize Performance Monitor (SYSMON).
Unlock 70-450 to see the answer
You've previewed enough free 70-450 questions. Unlock 70-450 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.