Red Gate forums :: View topic - SQL Server Base Monitoring service using excessive resources
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 2
SQL Monitor 2 forum

SQL Server Base Monitoring service using excessive resources

Search in SQL Monitor 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
mfal



Joined: 16 Sep 2011
Posts: 14

PostPosted: Tue Mar 27, 2012 7:33 pm    Post subject: SQL Server Base Monitoring service using excessive resources Reply with quote

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.
Back to top
View user's profile Send private message
andy.campbell.smith



Joined: 20 Oct 2011
Posts: 173
Location: Red Gate Software

PostPosted: Wed Mar 28, 2012 1:41 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
mfal



Joined: 16 Sep 2011
Posts: 14

PostPosted: Wed Mar 28, 2012 4:25 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
mfal



Joined: 16 Sep 2011
Posts: 14

PostPosted: Thu Mar 29, 2012 4:46 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 329
Location: Cambridge, UK

PostPosted: Thu Mar 29, 2012 5:18 pm    Post subject: Reply with quote

Please can you locate the SQL Monitor error logs, as described here:
http://www.red-gate.com/search/66647/2?u=%2Fsupportcenter%2FContent%2FSQL_Monitor%2Fhelp%2F3.0%2FSM_LogFiles&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
Back to top
View user's profile Send private message
mfal



Joined: 16 Sep 2011
Posts: 14

PostPosted: Thu Mar 29, 2012 6:46 pm    Post subject: Reply with quote

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.**
Back to top
View user's profile Send private message
EdCarden



Joined: 25 Nov 2008
Posts: 90

PostPosted: Fri Apr 13, 2012 5:13 pm    Post subject: Re: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group