SQL Server Performance Forum – Threads Archive
use connectionshi 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
where dbid = db_id(‘database name’) HTH Jasper Smith