SQL Server Base Monitoring service using excessive resources

SQL Server performance monitoring and alerting

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

SQL Server Base Monitoring service using excessive resources

Postby mfal » Tue Mar 27, 2012 7:33 pm

We're having an issue where SQL monitor is continually consuming more and more memory, up to the max of 16 GB of the server. It takes about 15 minutes from start of the hosting machine to consume this memory. During this time, the CPU is pegged at 100%. I have tried restarting the services, and the same behaviour occurs. Please advise.
mfal
 
Posts: 14
Joined: Fri Sep 16, 2011 8:07 pm

Postby andy.campbell.smith » Wed Mar 28, 2012 1:41 pm

Usually performance problems with SQL Monitor end up being caused by a poorly-performing SQL Server - the main culprit is the disk subsystems on virtual machines, because SQL Monitor does many bulk inserts the the write speed on virtual machines is typically sub-par. If data is queued for insert and the SQL Server cannot process it fast enough, that is when you see the memory of the base monitor service bloat up.

Additionally, the initial data burst you get when you add servers is sometimes more than the service can handle, so if you are adding servers to a new SQL Monitor installation, you may want to add one server, let it settle down for a few minutes, and add the next one.

I'm guessing you aren't adding a whole lot of new servers all the time - is this on a virtual machine?
Andy Campbell Smith

Red Gate Technical Support Engineer
andy.campbell.smith
 
Posts: 173
Joined: Thu Oct 20, 2011 11:19 am
Location: Red Gate Software

Postby mfal » Wed Mar 28, 2012 4:25 pm

The monitor services are on a virtual machine, but the instance hosting the database is not. We have not added any instances to Monitor for at least 2 weeks, and 2-3 weeks ago we had only added one instance to Monitor. That instance does reside on a 6 node cluster.
mfal
 
Posts: 14
Joined: Fri Sep 16, 2011 8:07 pm

Postby mfal » Thu Mar 29, 2012 4:46 pm

At this point I've allowed the services to run for 12 hours continuously. CPU is down to ~10% on the monitoring server, but RAM is still maxed out at 16 GB. The Monitor page is unresponsive. Please advise.
mfal
 
Posts: 14
Joined: Fri Sep 16, 2011 8:07 pm

Postby chriskelly » Thu Mar 29, 2012 5:18 pm

Please can you locate the SQL Monitor error logs, as described here:
http://www.red-gate.com/search/66647/2? ... &sp=google
Can you also describe the machines hosting the SQL Monitor components (base monitor, web service and data repository) e.g. OS version, RAM, SQL Server version etc. Fianally can you give me an idea of the number of machines and sql server instances that you are monitoring.

Please can you send these details to support@red-gate.com and quote the ticket number F0058852.
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Postby mfal » Thu Mar 29, 2012 6:46 pm

Is there an alternate way to get the error logs? The monitor page is currently unresponsive due to the resource use.

**EDIT: Found the text logs, attached them, email away.**
mfal
 
Posts: 14
Joined: Fri Sep 16, 2011 8:07 pm

Re:

Postby EdCarden » Fri Apr 13, 2012 5:13 pm

mfal wrote:Is there an alternate way to get the error logs? The monitor page is currently unresponsive due to the resource use.

**EDIT: Found the text logs, attached them, email away.**



What if any result came from investigating yoru log files? I'm cruious if this turned out to be an issue with the server hardware (i.e. I/O and ro disks) or if itwas something in SQL monitor.
EdCarden
 
Posts: 90
Joined: Tue Nov 25, 2008 6:26 pm


Return to SQL Monitor 2

Who is online

Users browsing this forum: No registered users and 0 guests