Post reply

Time of blocking

  • December 12, 2005 at 7:15 am

    #167385

    Hi all,

    How do i know how long a particular spid is blocking another process

    thanks

     


    Helen
    --------------------------------
    Are you a born again. He is Jehova Jirah unto me

  • December 12, 2005 at 7:30 am

    #608993

    Trace counters: Lock:Acquired and Lock:Released Event Classes.

  • December 12, 2005 at 8:09 am

    #609028

    Hi Josheph,

    But I did not have trace running on that time. I need to send a report to client. Can I start trace before killing the suspected process

    Thanks


    Helen
    --------------------------------
    Are you a born again. He is Jehova Jirah unto me

  • December 13, 2005 at 6:24 am

    #609182

    You can get this information from sysprocesses i.e. the process holding the lock and the processes that are blocked because of it and the time since they have had any activity.

    If you don't have it already, get the blocker procedure from Microsoft PSS site.  It takes the data from the system tables and presents it in a more readable form.  Sysprocesses will list the blocked processes, the last_batch, the open_tran etc..  Here is the link :

    http://support.microsoft.com/default.aspx?scid=kb;en-us;271509

     

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

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