troubleshooting Question

SQL Instances spike CPU, start being slow/refusing connections

Avatar of Dustin Saunders
Dustin SaundersFlag for United States of America asked on
Microsoft SQL ServerVMwareVirtualization
25 Comments2 Solutions221 ViewsLast Modified:
I've had an issue with some 2014 SP2 SQL servers, where multiple instances stop responding and have to be restarted before the applications can reconnect to them.

It's standalone instances, all on the same server.  Databases are on local store.

It seems like the problem comes from SQL server spiking up CPU usage (each instance is using 3-5% CPU non-stop).  Here's what is odd...  if I reboot the server it's <3% CPU usage average.  But if I restore a database into any one of those instances the server starts going CPU crazy after about an hour.  If I never restore a database, never a problem.

After the CPU starts going crazy, if I look at execution plans on all instances, the statistics are WAY off.  (expected 82 rows actual 22500)  Statistics look fine before issue starts.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 25 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 25 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros