February 5, 2016 at 6:15 am
I have observed following random behavior (SQL 2012, 32 GB RAM, Xeon E5)
CPU randomly spikes to 90% (normal average 15%)
Network response from pings spikes to 10-20 (normal 1ms)
What I am trying to understand is, which comes first.
Does a query cause high CPU usage and as a result a poor network response?
Or could poor network connectivity cause high CPU usage?
I could use advice on where to start looking when this issue occurs.
Obviously, when the issue occurs I will see a couple of queries in suspended state but at that point it is hard to tell if a query is the culprit.
Server environment is such that most DB tasks are of repetitive nature and hence there is a pattern to CPU load.
Thanks
February 5, 2016 at 6:48 am
It can be. You should investigate. This post of Paul will help you - http://www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/
Igor Micev,My blog: www.igormicev.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply