Home Forums Article Discussions Article Discussions by Author Discuss content posted by Ginger Keys Is This Database Being Used? RE: Is This Database Being Used?
Yuri Padorin
SSC-Addicted
Points: 414
More actions
December 4, 2017 at 7:32 am
#1970528
Surprised you didn't mention it, but I use an extended events session that I leave running to capture the login and source (among a few others) for a lock_acquired event. I filter by database and I filter out our maintenance and sysadmin accounts.