You work as a Systems Administrator at a company named ABC.com. You are in the process of
deploying new servers running SQL Server 2012.
You install a new server named ABC-SQL07. A week later, you receive reports of poor database
performance. You discover that at the times of poor performance, the CPU is running at nearly
100% utilization.
You need to recommend a monitoring solution for ABC-SQL07 that will send you an email alert if
the CPU utilization is more than 80%.
What should you include in your recommendation?
A.
Dynamic Management View.
B.
Policy-Based Management.
C.
SQL Trace.
D.
SQL Server Agent Alert.
Explanation: