SQLServerCentral.com / Administering / SQL Server 2005 / Alerting on session count / Latest PostsInstantForum.NET v2.9.0SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 02 Aug 2015 16:46:29 GMT20RE: Alerting on session counthttp://www.sqlservercentral.com/Forums/Topic1439674-146-1.aspxIf 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?CheersMon, 08 Apr 2013 10:08:24 GMTrodblokeAlerting on session counthttp://www.sqlservercentral.com/Forums/Topic1439674-146-1.aspxHiDoes 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 thanksSun, 07 Apr 2013 21:06:23 GMTC3PO's twin