SSMS 17.3 excessive memory usage
SSMS consumes large amounts of memory & CPU, even when idle. Disabling intellisense has no effect
Tried not to use SSMS for months. Now update it to v18.6 (SSMS 15.0.18338.0) still has the same problem. Open a statement file. Do nothing and after few minutes it goes up to over 2.6GB memory usage and SSMS hangs there. Disabled Intellisense and AutoRecover. Still has no effect. This become a big problem with SSMS. We are looking for other solutions to replacing SSMS with the next 5 working days.
Any solutions, Microsoft?????? This Problem is anoying.
Turn off intellisense, it must help!
be v commented
Same problem exists in 17.9.1 and 18 preview7.
Just edit scripts (stored procedure) without any execution, memory goes up to 2600 MB.
Is a SSD issue???? I use HDD few weeks ago and no problem.
Same here, but in my case it only seems to happen using a solution with multiple projects open. At a certain point during the day, it starts hogging memory until it uses almost 100%. Even idle, it will climb to near 100% then drop down to 85%, then start climbing again. Sometimes crashes out. At that point I have to reboot to be able to use the solution.
The project was created using SSMS 2016. Also maybe of importance, I do have SSMSToolsPak installed.
Still present in 17.9.1. Memory goes up to 3GB, freezes SSMS, goes down a few hundred MB. Goes back up, freezes, and back down. 'Tis a vicious cycle for sure.
So... Connect has been retired, none of the links above are available. Same issue here, and it persists. Any ideas?
The same problem exists in 17.9.1 and 18 preview.