Solved

SQL 2008 sqlserv.exe using using loads of ram

Posted on 2010-09-16
6
461 Views
Last Modified: 2012-05-10
Hi,
sqlservr.exe on Windows 2008 sbs 64bit running SQL 2008 is constantly maxing out the ram in the server.
There is 16gb installed and sqlservr.exe is using 7.5gb basically all of the free space.

If you restart the service it shrinks then grows again after a day or two.

Please help,

Regards,

Andy

0
Comment
Question by:actsystems-uk
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 3

Expert Comment

by:drpoppers
ID: 33692276
It alsways does that, SQL will grab every bit of ram it can to hold as much of the DB as possible, unless it's causing problems it should be fine.
0
 

Author Comment

by:actsystems-uk
ID: 33692296
It has slowed the server down to a crawl before - is there no way of defining a max amount of ram to be used?
0
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 250 total points
ID: 33692332
Kindly configure Min and Max Server Memory in SQL Server to allocate RAM for SQL Server.
And do let us know if there is any values already configured over there..
0
Portable, direct connect server access

The ATEN CV211 connects a laptop directly to any server allowing you instant access to perform data maintenance and local operations, for quick troubleshooting, updating, service and repair.

 

Author Comment

by:actsystems-uk
ID: 33692413
Hi rrjegan17,
I have been into Microsoft SQL Server management studio
right clicked the sql server > properties > Memory
set the maximum server memory (in mb) to 7000

the task manager shows sqlservr.exe at 7.5Gb

Is there another way of setting the min and max?

Regards,

Andy

0
 
LVL 39

Assisted Solution

by:BrandonGalderisi
BrandonGalderisi earned 250 total points
ID: 33692467
SQL Server will still consume memory for each connection to the server and other things slightly above what you set.  This is normal behavior.
0
 

Author Comment

by:actsystems-uk
ID: 33692585
thanks bit of a red herring that one - changed the value to 5gb and now it says 5.5gb in the processes so all sorted.

Thanks for all your help.

Regards,

Andy
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

The Need In an Active Directory enviroment, the PDC emulator provide time synchronization for the domain. This is important since Active Directory uses Kerberos for authentication.  By default, if the time difference between systems is off by more …
Trying to figure out group policy inheritance and which settings apply where can be a chore.  Here's a very simple summary I've written which might help.  Keep in mind, this is just a high-level conceptual overview where I try to avoid getting bogge…
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

729 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