Restart Server that DB is running on
Restart workstation that SQL Server 2008 Management Studio is running on
Start SQL Server 2008 and open file I'm editing
Edit the SQL file while while monitoring memory and processor usage on the workstation
Processor starts to spike, intellisense stops working, memory usage begins to climb to an absurd amount ~7G, management studio becomes almost nonresponsive (i.e. I can type and the text takes 30 seconds to 5 minutes to show up)
After about 30 mintues, memory usage drops to around 1.5G and management studio becomes semi-usable again. Intellisense sometimes goes back to working, sometimes everything has to be restarted again.
I've been working on this exact setup for 7 months now and this problem is new. No, I am not executing any statements - I am editing text only.
View Complete Post