Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 2 down vote favorite

On the db server, we have 4 GB of memory. Currently, the memory utilization of Sql Server 2005 on that server is 1,725,000 K and the total memory usage is stable at 2.04 GB. The Cpu usage on the server though is at 99% almost constantly.

How can I increase the memory that Sql Server uses so that it performs more operations using memory rather than reading from disk etc.?

share|improve this question
what architecture is the server? 32bit/64bit. – Shawn Melton Mar 26 '12 at 8:38
32 bit. Windows Server 2003 – sassyboy Mar 26 '12 at 10:25

1 Answer

up vote 3 down vote accepted

This is configurable through SSMS. However if you have a 32 bit build and are not booting with the /3GB switch the figures shown look suspiciously like the hard limits that will be imposed by the operating system anyway.

You can configure it from SSMS by right-clicking on the database server in the explorer, and you can see the memory usage policy under the 'memory' set of properties.

If you have a 32 bit server you may be able to use AWE to get more than your 2GB or so, although older versions of Std edition Windows (2003R1 and earlier) still restrict you to fairly small memory sizes. If you have a more recent version of the operating system and a 64 bit build you should be able to use up to 32GB of memory.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.