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:
· Share on Twitter

Comments

  • Andy C SAndy C S Posts: 173
    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
    · Share on Twitter
  • mfalmfal Posts: 19
    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.
    · Share on Twitter
  • mfalmfal Posts: 19
    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.
    · Share on Twitter
  • chriskellychriskelly Posts: 378
    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.
    · Share on Twitter
  • mfalmfal Posts: 19
    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.**
    · Share on Twitter
  • EdCardenEdCarden Posts: 138 Silver 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.
    · Share on Twitter
  • evkchaitanyaevkchaitanya Posts: 1 New member
    Redgate doing bulk inserts and eating up the memory.The server is timing out due to this.

    Any solution to fix this ?
    · Share on Twitter
  • Russell DRussell D Posts: 1,324 Diamond 5
    What version of Monitor are you using?
    Have you visited our Help Centre?
    · Share on Twitter
Sign In or Register to comment.