Post reply

LOCKS - How can I see what type of lock is applied by sql server

  • June 3, 2005 at 1:57 pm

    #89382

    Hi all,

     

    How can I see what type of lock is applied by sql server? Meaning Page lock, or table lock, etc.

    When I fire up Profiler and add all the Lock stuff, all I see is locks aquired and releasesed. Same with System Monitor locks counters.

     

    Thank you for the help

     

  • June 3, 2005 at 2:12 pm

    #563013

    use master

    go

    exec sp_lock

  • June 3, 2005 at 2:15 pm

    #563014

    off course, what a dumb***s I am!!

    Thank you

  • June 3, 2005 at 6:34 pm

    #563040

    Profiler also shows this information (if you need long time monitoring). Just make sure that you selected "Lock" events to monitor and selected "BinaryData" and "Mode" columns. "Mode"  describes the type of lock being applied to the resource and  "BinaryData"  shows locks type (Table, page etc.) in results pane.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply