Logs

Question

Logs

Admingod

SSCertifiable

Points: 5997
More actions
May 19, 2020 at 11:24 pm

#3753103

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.

Viewing 7 posts - 1 through 6 (of 6 total)

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

Phil Parkin SSC Guru Points: 246960 More actions · Answer 1

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?

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Admingod SSCertifiable Points: 5997 More actions · Answer 2

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.

Phil Parkin SSC Guru Points: 246960 More actions · Answer 3

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.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Admingod SSCertifiable Points: 5997 More actions · Answer 4

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.

Admingod SSCertifiable Points: 5997 More actions · Answer 5

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.

sterling3721 SSChasing Mays Points: 658 More actions · Answer 6

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.