SQL Prompt 8 Causing OutOfMemoryExceptions in SSMS 17.2

• 
  I think you can ignore this for now. I have been working with Microsoft on this and they think the problem is on there side. It just shows up because of SQL Prompt adding to the total memory usage.

  erenken August 28, 2017 15:45

  - 0 +
• 
  Hi,
  
  Thank you for your information @erenken. Can you give as an info when it will be repaired?
  
  Best regards
  Krzysztof

  krzysztofkroczak August 31, 2017 08:20

  - 0 +
• 
  I haven't heard anything about a timeline for a fix from Microsoft. When I hear something I will let everyone know.

  erenken August 31, 2017 12:16

  - 0 +
• 
  I have the same issue. And it always happens when I have a large resultset in the result tab.
  After closing the query tab everything works again.
  No more out of memory error. (Im using SSMS v17.2 - 14.0.17177.0)

  ThoschVX September 06, 2017 09:32

  - 0 +
• 
  Same issue here using SSMS v17.2.
  
  Any updates on the fix?

  vinx1127 September 13, 2017 06:35

  - 0 +
• 
  Nothing official, but follow these steps for the SSMS.exe fix it for me:
  
  http://gisgeek.blogspot.com/2012/01/set-32bit-executable-largeaddressaware.html
  
  Make sure to make a backup of SSMS.exe before you do this.

  erenken September 14, 2017 13:53

  - 0 +
• 
  Same issue here using SSMS v17.2 (also had it with 17.0 and 17.1)
  Followed erenken's instructions
  
  Here are the commands I used (your path may vary)
  Make a copy of "C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\Ssms.exe"
  
  Open Admin Command prompt
  
  Change Directory to C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\Extensions\Microsoft\ADL Tools\2.2.5000.0\CppSDK\VC\bin
  (This is where my Visual Studio editbin and dumpbin programs were located)
  
  editbin /LARGEADDRESSAWARE "C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\Ssms.exe"
  
  dumpbin /headers "C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\Ssms.exe" | more
  
  You should see "...Application can handle large (>2GB) addresses..."
  
  We shall see if this helps.

  MillhouseD September 20, 2017 15:46

  - 0 +
• 
  I believe this has been addressed in SSMS 17.3.

  erenken November 01, 2017 23:17

  - 0 +
• 
  I still get OOM errors in 17.3, even with no Redgate tools installed

  gbritton November 02, 2017 14:20

  - 0 +

Add comment

Please sign in to leave a comment.