What are the challenges you face when working across database platforms? Take the survey
Options

High Physical Memory Usage on Alert Repository Server

nuberfinnuberfin Posts: 18 Bronze 2
edited January 21, 2009 10:20AM in SQL Monitor Previous Versions
Hello

I have just installed SQL Response and placed the alert repository on a SQL 2005 instance server currently not in use as a production box. The SQL Response service is eating up around 1.2 GB of physical memory. Is this normal??

Comments

  • Options
    Hi nuberfin,

    That does sound a bit high, how many SQL Server instances is the alert repository monitoring?

    Does the memory usage fluctuate much, or does it seem constant?

    Thanks,
    --
    Daniel
  • Options
    nuberfinnuberfin Posts: 18 Bronze 2
    One instance. When I restarted the service yesterday, the memory stayed at around 200 - 300 MB. Most of the day. It appears that it swelled again last night and the service stopped completely at some point overnight and my connection to the repository was broken.

    So something appears to be swelling it's footprint then shutting down the service when it runs out of memory. The repository is on a production build of a SQL Server 2005 box that has yet to be placed into be deployed, so it's not doing any work other than backing up the system databases every night via an SSIS package scheduled via a SQL Agent job.

    Let me know if you need any additional information.

    Thanks!
  • Options
    dlkjdlkj Posts: 151
    edited April 7, 2010 10:58AM
    Hi nuberfin,

    Could you please zip up and send your Alert Repository Log Files

    You can find your alert repository log files at: C:\Documents and Settings\All Users\Application Data\Red Gate\Logs\SQL Response Alert Repository 1

    Thanks,
    --
    Daniel
  • Options
    nuberfinnuberfin Posts: 18 Bronze 2
    Done.

    Thanks!
Sign In or Register to comment.