use connections | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

use connections

hi we need to measure the number of user connections to a particular database , every hour on the hour, between 6am and 5pm. What is the best way to do this?? thank you in advance.
select count(distinct spid) — for parallelism
from master.dbo.sysprocesses
where dbid = db_id(‘database name’) HTH Jasper Smith
thanks Jasper