Finding LOCK table in SQL Server is one of essential task of DBA.
Locked table for long time in SQL Server adversary affect on performance
of the application, especially in pick business hours.
I have one SQL Server VIEW which help us to find all the table which are being locked currently along with duration since it is being locked.
Please read complete article here:
I have one SQL Server VIEW which help us to find all the table which are being locked currently along with duration since it is being locked.
Please read complete article here:
0 comments:
Post a Comment