Post reply

How to see CPU Consumption by each sql instance?

  • July 29, 2011 at 1:00 pm

    #254494

    Hi..

    we have 4 instances running on our sql server 2005 enterprise edition. from past couple of weeks we are getting alerts that CPU Consumption on this box is 60%.

    how do i query/check each sql instance is consuming CPU and how much?

    Thanks in advance.

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

  • July 29, 2011 at 1:04 pm

    #1361050

    This should get you started :

    http://msdn.microsoft.com/en-us/library/ms187743.aspx

  • August 1, 2011 at 8:24 am

    #1361574

    recently i had a server with a CPU issue. get SSMS 2008 R2 and use the activity monitor and check out the most expensive queries it reports back to you

  • August 2, 2011 at 6:53 am

    This was removed by the editor as SPAM

  • August 2, 2011 at 8:02 am

    #1362173

    WOW that's nice :w00t:.

  • August 2, 2011 at 8:14 am

    This was removed by the editor as SPAM

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

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