SQL Server Management Studio (SSMS) 2012: unusually high memory (leak?)

Question

1.3 GB of memory. I am using Windows 7 Ultimate 64-bit. I don't do much - just editing a stored procedure (there is no query running in the background and no query result).

I notice, however, this only happens sometimes - as if some garbage collection is knocked out, then it will return to its normal (about 100 MB).

Any ideas / workarounds / updates?

• Just an update on this: it looks like SSMS 2014 will no longer have this.

Answer 1

It seems that if you disable IntelliSense, memory consumption will decrease significantly and the software will become much more responsive. To disable it, go to Tools → Options → Text Editor → Transact-SQL → IntelliSense and uncheck the box. Save your work and run SSMS.

The main disadvantage is that you lose both IntelliSense and Code Outlining. Pretty bummer, but at least you can leave SSMS open for a few days without any problems.

Hope this helps. Greetings.

Answer 2

I ran into this problem while developing a stored procedure. If you work with any dynamic SQL code, the process will disappear and the application will stop responding. When I turn off Intellisense, this behavior is gone.