I'm having some issues with our Application "locking-up" on certain menus. Our DB is SQL Server 2005. In my research I've noticed that in SQL Server Management Studio there it an Activity Monitor.
What does the LOCKS BY OBJECTS tell me...? Are these ALL locks that have occured regardless of status,....OR.... is this a listing of CURRENT LOCKS on the system?