High Physical Memory Usage on Alert Repository Server
nuberfin
Posts: 18 Bronze 2
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??
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
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
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!
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
Thanks!