Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Alerting on session count Expand / Collapse
Posted Sunday, April 7, 2013 9:06 PM


Group: General Forum Members
Last Login: Wednesday, October 29, 2014 8:41 PM
Points: 17, Visits: 104
Does anyone know how I could create an alert on a database when a particular number of connected sessions is reached? We had an outage last week and I suspect that it was caused by this.

many thanks

Post #1439674
Posted Monday, April 8, 2013 10:08 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, November 23, 2015 8:34 AM
Points: 707, Visits: 700
If its for the entire instance, then Alerts, and define a SQL Server Performance Condition Alert on SQLServer:General Statistics, Logical Connections.

For a specific database, maybe something along the lines of scheduling:

select db_name(dbid), count(dbid) from sysprocesses group by DB_NAME(dbid), throw the output into a table and query it with a RAISEERROR or send dbmail to let you know that way?

Post #1439927
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse