Solved

SQLServer.exe Taking All Free Memory

Posted on 2006-11-03
3
505 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 143

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 143

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

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server Sum Over Multiple Tables 20 35
SQL Server Express or Standard? 5 32
Merge join vs exist 3 27
Neglected Questions 3 13
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
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…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

726 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