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
Author
Message
Posted Sunday, April 7, 2013 9:06 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 8, 2013 7:11 PM
Points: 17, Visits: 103
Hi
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
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 4:03 AM
Points: 592, Visits: 524
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?

Cheers
Post #1439927
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse