SQL Server Management Studio CPU and RAM usage keeps increasing for no reason
Solution 1
I managed to bring it down from 2.5 GB to 150KB by disabling Auto Recover.
Before
After
Solution 2
The problem is here with Intelligence. I had a same problem today. After opening a 60kb of SQL file in SSMS, it is taking nearly 2GB of my RAM.
Anyway I figured it out. This is because the incomplete code or Joins written in that query window. If I comment out that incomplete code snippet it became normal. Check for the joins which are not closed ON condition etc or comment it out until you finish writing it.
You can see that in below pictures, memory observations before and after commenting incomplete code. It came to 128MB from 1.2GB
With Incomplete code
Related videos on Youtube
rcs
Updated on September 18, 2022Comments
-
rcs almost 2 years
I have a weird problem with SQL Server Management Studio, version 11.0.2100.60. When I was writing some query, sometimes the CPU gets hogged, and RAM usage keeps increasing. Usually closing and reopening SSMS will solve the problem, but it is quite annoying if I have to do this multiple times.
How to solve this issue?
[UPDATE]: I ran the PerfView to analyze the CPU usage. But I'm not quite sure how to troubleshoot from there:
PerfView CPU Stacks, showing ssms using a lot of CPU resource:
Drilling down Ssms. Looks like this ntdll is taking the most resource:
-
rcs over 6 yearsFor my case, after I wait for some time, the memory usage will come back to normal. But this is frustrating as I have to waste my time. So I decided to turn off the Intellisense instead.
-
Shakeer Mirza over 6 yearsWorking without intelligence is so pathetic.. its ok
-
jerrylagrou over 6 yearsSmaller, more modular files will also help.