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: