Marcus Aurelius
asked on
SQL Mgmt Studio - ACTIVITY MONITOR >> LOCKS BY OBJECT....?
Experts,
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I am sorry, I hit the wrong tab and therefore the wrong question! Oops! Please ignore!
You dont need to write it into a file, you can redirect it into memory if you like.
Open in new window