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 |
|
Jayam.cnu
Starting Member
45 Posts |
 Posted - 2012-06-29 : 03:47:50
|
| Hi,I'l like to get the DBs status on a Server. Means, I need to know what are the DBs are being used, what are not being & if any are in use, I need to know when it was used last time and how frequently it’s been used in the past several month.Sreenivasulu.p,Mail ID: sreenivas.puliverthi@gmail.com |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2012-06-29 : 18:14:46
|
| Have you looked into sp_who and/or sp_who2 as a means of getting a snapshot of activity? As for the historical data, I think you'll need to sample the snapshot at regular intervals and store the results in a table. A SQL Job could be scheduled to do this.=================================================I don't know what your destiny will be, but one thing I do know: the only ones among you who will be really happy are those who have sought and found how to serve. -Albert Schweitzer |
 |
|
|
|
|
|
Need to get DB status on a Server