SQLTeam.com | Weblogs | Forums

Generate auto email if connections on DB exceed


#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