Post reply

Lock Wait

  • July 24, 2013 at 4:40 am

    #277930

    Hi,

    How to find out the total amount of time spent on lock wait event using T-SQL Query

  • July 24, 2013 at 4:47 am

    #1635282

    Does this suite your purpose?

    select *

    from sys.dm_os_wait_stats

    where wait_type like 'LCK%'

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

Viewing 2 posts - 1 through 1 (of 1 total)

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