WinTill :: Knowledge Base



Display SQL Server Currently Running Processes

To find out what sql server is currently processing, you can do this by:-

  • using Enterprise Manager and looking at current activity 
  • using the system stored procedures sp_who2 or sp_who
  • sp_who2 works quite well. It displays a result list of all processes that SQL is currently working on, its current status e.g. Sleeping, Running, Background etc, who instigated the process including hostname if applicable.



    Related Articles

    No related articles were found.

    Attachments

    No attachments were found.

    Visitor Comments

    Article Details

    Last Updated
    7th of March, 2011

    Would you like to...

    Print this page  Print this page

    Email this page  Email this page

    Post a comment  Post a comment

     Subscribe me

    Subscribe me  Remove from favorites

    Remove Highlighting Remove Highlighting

    Edit this Article

    Quick Edit

    Export to PDF


    User Opinions

    No users have voted.

    How would you rate this answer?




    Thank you for rating this answer.

    Continue