Post reply

Locks by Process in Activity Monitor - is it in ther

  • December 10, 2009 at 9:41 pm

    #228531

    Can anyone explain to where I find locks by process in Activity Monitor on SSMS 2008?

    Thanks,

    Jason

  • December 10, 2009 at 10:09 pm

    #1090986

    Microsoft decided to change this part in 2k8.

    Right Click on your instance, and you'll find "Activity Monitor" in the list.

    use the "Resource Waits" drop down (may I say tab?)

    alternatively, just use SP_Who2.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • December 12, 2009 at 10:02 am

    #1091546

    this software is very useful,. it shows query locks.

    after that you know who does these locks by the position you may need to use query hints like (nolock,fastfirstrow,...)

    for example :

    select * from tbl with (nolock)

    update tbl with (fastfirstrow) set col = value ...

  • December 13, 2009 at 7:54 pm

    #1091741

    Also take a look at MVP Adam Machanic's excellent WhoIsActive procedure. I rarely use Activity Monitor now.

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi

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

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