Redgate.Repsonse.Base.SErvice high RAM usage

MillMats

We have been running SQL Monitor for a few years now and have recently notice high RAM usage on the Redgate.Response.Engine.Alerting.Base.Service.exe. Memory usage was stable at 4G+, so I restarted the service and it immediately jumped up to 2G+. 
We are only monitoring one production server (2008R2) with SQL 2008 R2, containing about 35 databases. 

MillMats

Update: I found errors in Event Viewer on the hosting server, regarding RedGate authentication failures. I reconfigured the email used for notifications and set redgate to use an AD account. Tested both connections successfully.  I then restarted the mentioned service and it didn't automatically go back to 2G+. It steadily rose to 500M, then slowly increased (over several minutes) to 600M, then 700M and is still on the rise.

Russell D

What version of monitor are you running? We've fixed a few memory leaks in recent issues, and specifically one to do with AD.

MillMats

Red Gate SQL Monitor 7.1.5.8837 

Russell D

Right well that certainly won't have any recent fixes in it then. If you can't upgrade off v7 for whatever reason I'd at least ensure you're on the last release of that version (http://download.red-gate.com//checkforupdates/SQLMonitorWeb/SQLMonitorWeb_7.1.20.11693.exe) as there was a lot of further releases of it.

MillMats

Wow - that's a huge improvement! Before I ran the installer for the supplied version, Memory usage was over 5G. After the upgrade/install, its under 1G and doesn't seem to be rising. Thanks!

MillMats

I may have celebrated too soon - up to 3.6G

Russell D

I can only really suggest taking a couple of crashdumps and then trying to find out whats causing the memory to rise. Since you're on SQL 2008 R2 it could be some sprocs that we know caused problems, eg xp_readerrorlog, or it could be any number of problems really. Are you tied to using such an old version?

MillMats

I"m tied to any monitor version that will install on, and work on, SQL 2008 R2.  I don't think v9 will, but I'm open to installing/updating to whichever version #  will work.

Russell D

You can install v8 on a 2008 R2 database, but we dont know whats causing the memory leak so it's hard to say if its worth upgrading.

Taking a few crashdumps and then comparing after some memory usaage would be a way of identifying if its definitely Monitor, but even at that stage, we can't issue code fixes to old versions so I'm not sure what would be the best way to proceed.

MillMats

I created a dump file, which is over 5G, so I'm not sure how useful it will be, if it will even open LOL. Can you DM a link to v8? I don't see any way to get to previous versions on the site.

Russell D

The last v8 release was here: https://download.red-gate.com//checkforupdates/SQLMonitorWeb/SQLMonitorWeb_8.0.27.19820.exe. 

It's also worth just ensuring your sql is fully patched.