PrepAway - Latest Free Exam Questions & Answers

What should you do?

You are managing a Microsoft SQL Server 2005 Analysis Services (SSAS) instance. You notice unusually high CPU utilization in the msmdsrv.exe every day during business hours. You need to identify the source of the high CPU utilization without requiring user interaction to stop and start traces. What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Use Database Engine Tuning Advisor.

B.
Examine the Connection object from System Monitor.

C.
Configure a scheduled task that launches Microsoft SQL Server Profiler as a command-line utility.

D.
Configure the SSAS instance to log queries for future use by using the Usage-Based Optimization Wizard.


Leave a Reply