SQLServer.exe Taking All Free Memory

When I logged into Windows XP Pro this morning, the SqlServer.exe process had taken all of the free memory (500M) for itself. Why would it do that? Logging out and back in did not correct it, but restarting did.
Who is Participating?
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
open the enterprise Manager
edit the instance properties
go to the memory tab

reduce the max memory setting from the full ram available to let's say 200 MB on your XP Pro.
close the form.

Guy Hengel [angelIII / a3]Billing EngineerCommented:
>Why would it do that?
as by the default configuration, every RDBMS will take as much memory as possible, because that's the main point of keeping best performance.
ususally, you should only have a single server application installed...
sanjaykpConnect With a Mentor Commented:
Sql Server will grab as much memory as it can off the OS since it tries to load as many db's as it can into memory. (Reading memory is quicker than reading disks). If your server does not have enough memory, you can allocate SQL Server to use only a certain amount of memory. Go to EE, right click on your instance and open properties. In the memory tab you can dynamically configure the max memory you want SQl Server to use. As soon as you reduce the memory, SQL Server will give back it's memory to the OS.

When you logged out, the SQL instance was still in memory. When you restarted it, the SQLServer.exe process was released from memory and reloaded into memory.

Hope that helps.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.