Generate auto email if connections on DB exceed

SQL Server Administration
1

I want to generate an auto email if number of connections on database exceed. How can I do that?

2

Set up an Alert under SQL Server Agent

Object: SQLServer:General Statistics
Counter: User Connections
Instance: instance name if multiple instances
Alert if counter rises above: your max

Response: Notify operators

Choose who gets the email.

note you have to set up operators first

3 Likes