sql server: View lock information using Activity Monitor

Hi experts, can give me a hand on lab or something to do this:
View lock information using Activity Monitor
enrique_aeoAsked:
Who is Participating?
 
dbaSQLConnect With a Mentor Commented:
Have you seen this?
http://www.mssqltips.com/tip.asp?tip=1917

I think you need to take a look at the 'Resource Waits' section.
http://www.networkworld.com/community/node/32224


ยง    Resource Waits -  This section displays resource waits  vertically that are based on the following wait categories CPU, SQLCLR, Network I/O Latch, Lock, Logging, Memory, Buffer I/O, Buffer Latch and Compilation.  From a horizontal perspective, the Wait Time, Recent Wait Time, Average Waiter Counter and Cumulative Wait Time metrics are published for each Wait Category.  Similar to the Processes section, data can be filtered based on items within a column.

0
All Courses

From novice to tech pro — start learning today.