Solved

SQL 2008 sqlserv.exe using using loads of ram

Posted on 2010-09-16
6
454 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
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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 

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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Problem with SqlConnection 5 123
Independent domain networks for setup 6 84
Group Policy Question 7 36
BULK LOGGED - log full 9 17
We recently endured a series of broadcast storms that caused our ISP to shut us down for brief periods of time. After going through a multitude of tests, we determined that the issue was related to Intel NIC drivers on some new HP desktop computers …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

746 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

8 Experts available now in Live!

Get 1:1 Help Now