|
Hommer
Aged Yak Warrior
693 Posts |
 Posted - 10/15/2012 : 12:39:42
|
Hi,
I am on sql server 2008 R2 enterprises.
Is there any system built-in tables/views that I can query against to retrieve user connection count over time?
I can use sp_who2 to sum the SPID at any given time. But if I want to know, say last 3 days from 7 AM to 6 PM total connection count on the hour, all I can think of is to build my own table and write into it using agent/job.
Am I going after this the hard way?
Thanks!
|
Edited by - Hommer on 10/15/2012 15:28:33
|
|
script to retrieve connect info over time
