November 17, 2003 at 7:32 am
Hi,
Any suggestions/hints on how to track and document <SQL 7.0 on NT4> multiple database activity/usage to determine if they are being accessed by users/apps frequently or are relatively static.
I'd like to use the results to implement an appropriate backup startegy ie: which databases should have more frequent db or log backups ....
Many thanks.
Jeff
Many thanks. Jeff
November 18, 2003 at 9:13 pm
You can run traces with profiler for this
Ray Higdon MCSE, MCDBA, CCNA
------------
Ray Higdon MCSE, MCDBA, CCNA
November 26, 2003 at 3:21 pm
Have a look at this article...
http://www.sqlservercentral.com/columnists/hji/trace.asp
I have found it invaluable in identifying databases which are rarely used.
Cheers,
Kevin
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply