SQL Monitor Causing CPU Spikes

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

SQL Monitor Causing CPU Spikes

Postby Rhys » Tue May 15, 2012 6: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 1:20 pm

Postby chriskelly » Wed May 16, 2012 7: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: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Return to SQL Monitor 2

Who is online

Users browsing this forum: No registered users and 0 guests