Redgate.Repsonse.Base.SErvice high RAM usage

• 
  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.

  MillMats July 11, 2019 15:14

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

  Russell D July 15, 2019 07:14

  - 0 +
• 
  Red Gate SQL Monitor 7.1.5.8837

  MillMats July 15, 2019 12:06

  - 0 +
• 
  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.

  Russell D July 15, 2019 12:30

  - 0 +
• 
  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 July 15, 2019 12:38

  - 0 +
• 
  I may have celebrated too soon - up to 3.6G

  MillMats July 15, 2019 18:17

  - 0 +
• 
  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?

  Russell D July 16, 2019 10:51

  - 0 +
• 
  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.

  MillMats July 16, 2019 12:41

  - 0 +
• 
  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.

  Russell D July 16, 2019 12:59

  - 0 +
• 
  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.

  MillMats July 16, 2019 14:03

  - 0 +
• 
  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.

  Russell D July 18, 2019 08:14

  - 0 +

Add comment

Please sign in to leave a comment.