SQL Monitor Causing CPU Spikes

Monitor, diagnose and receive alerts to problems across your SQL Servers.

SQL Monitor Causing CPU Spikes

Postby Rhys » Tue May 15, 2012 5:25 pm

I noticed some CPU spikes today on all our SQL Servers Monitored by SQL Monitor. All of these spikes were pretty much around the same time so we looked into it.

After a looking at a few things we realised the PC where we run SQL Monitor on had been rebooted a few times. These reboots seems to correspond with the CPU spikes.

So we tested it by rebooting SQL Monitor again and sure enough it case the CPU spikes on all monitored servers.

These spikes don't last very long but they do reach close to 100% (maxing out on some occasions)
Posts: 21
Joined: Wed Dec 01, 2010 12:20 pm

Postby chriskelly » Wed May 16, 2012 6:10 pm

I believe that when the Base Monitor service re-establishes contact with a monitored entity it will run some quick data connection tests to ensure that it has contact. However, the spikes that you describe do sound out of the ordinary.

Would it be possible for you to send me the SQL Monitor error logs, as described in this document, by emailing support@red-gate.com and quote the ticket number F0060280 in the subject line:
http://www.red-gate.com/supportcenter/c ... M_LogFiles
Chris Kelly
Technical Support Engineer
Posts: 368
Joined: Mon Apr 19, 2010 12:44 pm
Location: Cambridge, UK

Return to SQL Monitor Previous Versions

Who is online

Users browsing this forum: Yahoo [Bot] and 0 guests