You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01.
You need to be notified immediately when fatal errors occur on Server01.
What should you create?
A.
A Database Audit Specification
B.
A Policy
C.
An Alert
D.
A SQL Profiler Trace
E.
A Resource Pool
F.
An Extended Event session
G.
A Server Audit Specification
Explanation:
SQL Server has alerts that get more important based on the severity of the alert. Anything of severity 16 or
below tends to refer to the database and deals with issues that are tied to syntax errors, violations of foreign
keys, etc. While those errors are typically important, they don’t refer to anything with regards to overall health of
the SQL Server. Alerts 17 through 25 do. Those are the ones your health checks are probably firing on.
https://www.mssqltips.com/sqlservertip/3384/configuring-critical-sql-server-alerts/
