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