What are the most likely causes of spikes in CPU usage to 99% for dbsrv10.exe, or more recent versions of dbsrv*.exe for that matter? Thanks in advance.
asked 12 Feb '14, 17:34
Any query that either does lots of computations (e.g. stored procedure execution) or iterates over lots of rows that are already in cache (i.e. does not require any I/O ... or the I/O read-ahead can stay ahead of the executing query) will cause the CPU to 'spike' to 100%. I.e. the server will execute full-tilt until either it needs to wait for I/O, blocks on a lock, blocks on a 'WAIT FOR ...' or similar statement, hits a sync point (waiting for the client to fetch or rows), or completes.
answered 12 Feb '14, 19:02