You are creating an alert for your SQL Server database. Which of the following is not a metric that you would select?
CPU percentage
Total DB Size
Memory usage Failed connections
Deadlocks
Answers
Explanation:
नखभनटोडःएफःवशॅफदडधझन
Answer:
Final Answer.
Explanation:
Given,
that we are creating an alert for our SQL Server database.
Concept,
Events are generated by SQL Server and entered into the Microsoft Windows application log. SQL Server Agent reads the application log and compares events written there to alerts that you have defined. When SQL Server Agent finds a match, it fires an alert, which is an automated response to an event. In addition to monitoring SQL Server events, SQL Server Agent can also monitor performance conditions and Windows Management Instrumentation (WMI) events.
To define an alert, you specify:
The name of the alert.
The event or performance condition that triggers the alert.
The action that SQL Server Agent takes in response to the event or performance condition.
Therefore,
The correct answer will be Total DB Size.
#SPJ2