Question

You manage a SQL Server 2022 instance running on an Azure VM. During recent month-end processing, the server experienced sustained high workload that went unnoticed until users complained. You want SQL Server Agent to automatically send you an email whenever the 'Batch Requests/sec' counter exceeds 5,000. What type of SQL Server Agent alert should you create?

Accepted Answer

A SQL Server performance condition alert that monitors the SQLServer:SQL Statistics object's Batch Requests/sec counter with a 'rises above' threshold of 5000

Answer

A SQL Server event alert filtered by error number that fires when a specific severity level message is logged

Answer

A WMI event alert using a WQL query against the __InstanceModificationEvent class

Answer

A SQL Server event alert filtered by severity level 17 (insufficient resources)