Monitoring databases

  • I am trying to see which databases been used and which are not, I am trying to clean the server. Any ideas how I can do that?Thank you

  • Either use third party tool like SQL diagnostic manager or else you can run profiler for a week on those particular databases and collect data into a table. If nothing is happening on those databases, profiler would keep running but will not collect data and won't be space issue.

    SQL DBA.

  • I would do very simple test... go and check the .mdf and .ldf files on the operating System. Check for Date modified. Thats when these databases were used ( insert/update/delete statements were ran), running a select statement will not change modified date...

    Hope this helps,

    Imran Mohammed.

  • Take offline and see if anyone complains 🙂

  • I favor the offline approach, but you're likely to upset some people. Instead, if you suspect something isn't being touched, set it to autoclose. It will close, but more importantly, it will mark a record in the error log. If someone accesses it, there's a slight delay as it's opened and a log record it written.

    These can sit there, and if you don't see the open message in the log after a few months, I'd back them up, save the tape, and delete them.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply