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 |
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
 Posted - 2006-08-15 : 12:30:53
|
| Guys -We're affraid that a previous developer on our team created too many databases and some of these database now are inactive, are the any stored procedure that could give me a report of activity for each db on the system ?Thanks in advance!---Thanks!Igor. |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-08-15 : 12:44:00
|
| I think u can make use ofProcess Info in Enterprise Mngr orSQL ProfilerSrinika |
 |
|
|
druer
Constraint Violating Yak Guru
314 Posts |
Posted - 2006-08-15 : 15:37:13
|
| As indicated you can see that information via Enterprise Manager or you can issue a command to get the same information in the Query Analyzer. [CODE]select * from master.dbo.sysprocesses order by dbid[/CODE] However, I'm not sure that either method will really tell you anything. All it tells you is that at this time Activity is taking place on certain databases. So if activity is taking place then you know the database IS being used. But the absence of processes running at any given time does NOT indicate that the database isn't used, just that it wasn't being used at that time. If you have no background jobs that do any maintenance in the databases you could check the DATETIME stamp on the physical files to see when the last activity was performed on the data file for the databases to get a good idea of whether it is active or not.Hope it helps,DaltonBlessings aren't so much a matter of "if they come" but "are you noticing them." |
|
|
|
|
|
|
Database(s) activity