Solved

SQLServer.exe Taking All Free Memory

Posted on 2006-11-03
3
502 Views
Last Modified: 2008-02-01
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.
0
Comment
Question by:GivenRandy
  • 2
3 Comments
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 350 total points
ID: 17866396
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.

0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 17866408
>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...
0
 
LVL 3

Assisted Solution

by:sanjaykp
sanjaykp earned 150 total points
ID: 17866438
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.

Cheers
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now