I have a server running Windows Server 2012 with a default instance of SQL Server 2012 Express running on it. The server has 16GB of RAM in it and runs a number of other apps. SQL 2012 Express is supposed to be limited to 1GB of RAM. I
have seen the server go well over 5GB of usage for the sqlserver.exe service. A couple of days ago, I adjusted the "Maximum server memory (in MB)" to 1024 to force it to 1GB and rebooted the server.
I just looked at this server and the sqlserver.exe service is using almost 9GB of RAM.
What can I do to really limit this usage? It is supposed to be capped by the software, yet it still goes way up. I have forced a limitation in the software, yet it still goes way up. This used to work fine in SQL 2000 MSDE.
Any assistance would be greatly appreciated!
My.Settings.Signature = Nothing
Go to the complete details ...