SQL Server Base Monitoring service using excessive resources

mfalmfal Posts: 19
edited April 13, 2012 12:13PM in SQL Monitor Previous Versions
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.
Tagged:

Comments

  • 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
  • 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.
  • 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.
  • 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 [email protected] and quote the ticket number F0058852.
  • 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.**
  • EdCardenEdCarden Posts: 104 Bronze 2
    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.
  • Redgate doing bulk inserts and eating up the memory.The server is timing out due to this.

    Any solution to fix this ?
  • What version of Monitor are you using?
    Have you visited our Help Centre?
Sign In or Register to comment.