Solved

SQLServer.exe Taking All Free Memory

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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Simple SQL query from two tables 13 53
Help Required 3 94
Why i am getting a star, SSMS does not show me any error. Division Error 5 20
SQL View nearest date 5 35
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

776 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