Post reply

how to find what is causing the cpu spike using performance dashboard

  • June 2, 2014 at 12:56 pm

    #292011

    Hi, I am attaching the performance dashboard screen shot that I ran just now. I noticed that wait time % is almost 87%. Does that mean we have IO issue? I am trying to isolate the issue but not sure how to proceed[/url][/img]

  • June 4, 2014 at 12:43 pm

    #1718972

    HI,

    You will need to get more detailed information to get any focused answer to the problem you are seeing. If the tool you are using does not have object-level data, then a good tool for that is sqlnexus. Review the documentation at this site (http://sqlnexus.codeplex.com/) , and collect some data and run sqlnexus.exe to view its reports. I have found the Blocking and Wait Statistics Reports extremely useful and it will get you object-level data that you can use to narrow your investigation into the root causes of the issue. If after running this tool, you don't see blocking and locking caused by specific objects then you might look into other toolsets that would allow you to assess your IO subsystem.

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

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