Link to home
Start Free TrialLog in
Avatar of Baber Amin
Baber AminFlag for Canada

asked on

Table lock escalation time

Database: MS SQL Server

Hi,

Is there a way to know a particular table was locked

1. How many times
2. On which date and time

Thanks.
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

No, there's no history of locks.
The only way I can see doing that is to create your own solution by running a 24h audit system and store that information in a database so you can analyze it after.
Avatar of Baber Amin

ASKER

OK.
So what does that mean to fire a trigger whenever a lock occurs and store that info in a separate database?
ASKER CERTIFIED SOLUTION
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial