| Author |
Message |
mfal
Joined: 16 Sep 2011
Posts: 10
|
 Posted: Tue Mar 27, 2012 7:33 pm Post subject: SQL Server Base Monitoring service using excessive resources |
 |
|
| 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 |
|
 |
andy.campbell.smith
Joined: 20 Oct 2011
Posts: 124
Location: Red Gate Software
|
| Posted: Wed Mar 28, 2012 1:41 pm Post subject: |
|
|
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 |
|
|
mfal
Joined: 16 Sep 2011
Posts: 10
|
| Posted: Wed Mar 28, 2012 4:25 pm Post subject: |
|
|
| 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 |
|
|
mfal
Joined: 16 Sep 2011
Posts: 10
|
| Posted: Thu Mar 29, 2012 4:46 pm Post subject: |
|
|
| 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 |
|
|
chriskelly
Joined: 19 Apr 2010
Posts: 251
Location: Cambridge, UK
|
|
| Back to top |
|
|
mfal
Joined: 16 Sep 2011
Posts: 10
|
| Posted: Thu Mar 29, 2012 6:46 pm Post subject: |
|
|
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 |
|
|
EdCarden
Joined: 25 Nov 2008
Posts: 66
|
| Posted: Fri Apr 13, 2012 5:13 pm Post subject: Re: |
|
|
| 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 |
|
|
|
