SQL Server performance monitoring and alerting
Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer
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
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 firstname.lastname@example.org
and quote the ticket number F0060280 in the subject line:
http://www.red-gate.com/supportcenter/c ... M_LogFiles
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