Post reply

SQL Server 05 activity monitoring

  • July 31, 2008 at 1:29 pm

    #130427

    I am new and need to understand how to monitor blocking processes in SQL Server 2005. I use the activity monitor and sp_who2 frequently.

    Activity monitor is under servername>>management in object browser.

    My question is:

    What does the green check mark mean in the activity monitor ?

  • July 31, 2008 at 1:30 pm

    #851512

    The green check mark signifies a running status.

  • July 31, 2008 at 4:39 pm

    #851583

    Thanks a lot.

    How can I find the Job ID of the proc that is blocking or is stuck in runnable state? So that I can see the job id in the scheduler and know when it is going to execute.

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

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