SQL Server Express 2012 process takes a lot of memory
Posted on 2013-06-27
I'm using SQL Server Express 2012 on Windows8. Looking at the memory usage of SQL Server Express service in Task Manager I see:
Before running SSMS: 10 MB.
During SSMS usage: 35 MB.
(Long) after closing SSMS: 154 MB! the process is stuck in memory, and remains like that until I end it manually or restart Windows.
Is this behaviour normal? Is there anyhing I can tune in SQL Server so that the process won't stuck in memory?