Extreme-Advice: Find locked table name with duration and count in SQL Server

Tuesday, September 25, 2012 |

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: