Exception of type 'System.OutOfMemoryException' was thrown. on a simple select query !!!!

• 
  Hi @ssudharma
  
  Can you please have a look of this page?
  https://documentation.red-gate.com/sp9/managing-sql-prompt-behavior/managing-connections-and-memory
  

  Tianjiao_Li August 13, 2018 15:59

  - 0 +
• 
  Hello @Tianjiao_Li ,
  
  I tried the above approach of unloading and reloading as well as removing the suggestions. it works for a few mins and reverts back to the same behaviour.
  
  Can you please provide a different approach towards perhaps limiting the memory consumed by redgate?

  ssudharma August 20, 2018 21:04

  - 0 +
• 
  Hi @ssudharma
  
  How many databases you have loaded suggestions for when the out of memory issue occurs for you?
  
  You can limit the memory by limit the number of databases you load suggestions for. 
  
  Also which version of SSMS do you use? If it's bellow 17.3, you can raise the amount of RAM available to SSMS by using the Large Address Aware utility on ssms.exe (see https://www.techpowerup.com/forums/threads/large-address-aware.112556/)

  Tianjiao_Li August 30, 2018 15:22

  - 0 +
• 
  Hello @Tianjiao_Li ,
  
  I have about 7 databases loaded and have restricted the ones to be loaded up by the sql prompt to just 2 databases. I do use a SSMS 12.5 version, however, i wont be able to install 3rd party applications on my machine due to limitations at work. 
  
  Is there any setting on the Redgate itself that I can tweak ?
  
  Thanks
  Srikanth

  ssudharma August 30, 2018 15:47

  - 0 +
• 
  Hi @ssudharma
  
  I'd like to have a look of your log file to investigate the issue further. I'll reach you by email shortly.

  Tianjiao_Li September 04, 2018 08:56

  - 0 +

Add comment

Please sign in to leave a comment.