In SQL server 2000 and 2005, I used to have a nice practical list of all SQL Server sessions and list of locks with useful details make troubleshooting quite easy.
In SQL Server 2008 list of locks are taken out from the “Management” section of SSMS and there is a clumsy “Activity Monitor” option which
doesn’t provide information about sessions and locks in the nice way we used to have in SSMS 2005.
Using SSMS 2008, Is there any way to get the same list of locks and sessions similar to what we had in SSMS 2005?
View Complete Post