May 19, 2020 at 11:24 pm
Can you check if anyone is using the database based on the logs? Want to check if anyone is accessing the db. If yes, with logs how is that possible? I was thinking of checking with schema changes in the db.
May 19, 2020 at 11:52 pm
Can you check if anyone is using the database based on the logs? Want to check if anyone is accessing the db. If yes, with logs how is that possible? I was thinking of checking with schema changes in the db.
This link, regarding the default trace, may be of interest.
sp_who2 shows you who is 'using' a database.
What are you trying to achieve with this?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
May 20, 2020 at 6:20 pm
I don't see any activity against the db. Before taking it offline i wanted to make sure when it was last used or something like that.
May 20, 2020 at 6:26 pm
Fair enough. I'd be tempted to take it offline early one morning and then keep an ear open for the Help Desk calls ... Maybe that's why I'd make a poor DBA.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
May 20, 2020 at 9:58 pm
Would there be any entry in the logs if this database was previously used, don't have auditing and doesn't look it is used in anywhere.
May 20, 2020 at 10:02 pm
I also looked at the transaction logs growing or differential and see how big they were. Is this too simplistic? Obviously that would only show transaction activity, which can be not enough to prove a database is used.
May 20, 2020 at 10:58 pm
disable one user per day, and see if there is anyone yelling/calling helpdesk. transaction logs only tracks changes to a database, not for select. And reindex could change tlog, too, so not really complete nor correct.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply