SQL Server utilising lots of Memory

Nat Wallis
Nat Wallis used Ask the Experts™
Just setup a new SBS2008 box. Dual Xeon 5520, 4x 1TB SAS drives, 12GB ECC DDR3 RAM, Adaptec 5805 RAID controller. So fairly decent.

Anyway after going thru and doing a few things on the unit I noticed that memory usage was about 70%!

the SQLAgent.exe is using about 6GB of RAM!! And its doing not much. SBSMonitoring, WSS3 (nothing in there) and any other imbedded datatbases but that is it. What is going to happen when I actually start using SQL for some things.

Just wondering if there is anything I can do about this? I understand that its going to need some RAM etc but surely to start off with it doesnt need 6GB and then increase from there.

(*** I have installed just SBS2008 Standard, and havent installed the optional full SQL software so I am assuming its like a cut-down SQL2005 version ***)
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
That's typical, so don't worry too much about this. SQL (and exchange) are memory hogs and will use up any memory that is available, whether it's 2 GB's or 12 GB's. If other programs need RAM SQL will give up RAM so that another program can use it.
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018
SQL Server 2005 will utilize whatever memory is in that system.

In order to work correctly, Specify your Min and Max Server Memory to get Physical Memory available for other applications in the machine.

Just set your Min Server Memory to 4 GB and Max Server Memory to 10 GB of RAM and you will be able to see the difference.
Nat WallisTechnical Services Manager



Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial