SQL Server Sessions

 

SQL Statement

select * from sysprocesses where status in ('runnable','running')

Description

Counts the number of user sessions currently connected to the database and alerts the "DBAs" when that exceeds 100.