Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Hommer
Aged Yak Warrior
808 Posts |
 Posted - 2012-10-15 : 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! |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-10-15 : 16:13:58
|
| You could use auditing.-Chad |
 |
|
|
|
|
|
script to retrieve connect info over time