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.
Yamaha

---

select count(distinct spid) — for parallelism
from master.dbo.sysprocesses
where dbid = db_id(‘database name’) HTH Jasper Smith

---

thanks Jasper

---

]]>