Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

i'm a developer and when i deploy our site to the prod server (with 3GB of ram) i always see the mssql proces using 1 GB of ram. We're at startup, so the database doesn't realy do a lot (sometimes no requests for 10 minutes).

Is the 1GB a lot at that moment? or does SqlServer have some kind of lowerbound memory usage?


share|improve this question
up vote 2 down vote accepted

1 GB isn't really all that much for MS Sql Server - our Sql 2005 cluster machine use 3 GB when generally quiet, and while we're not a startup, we don't have a particularly taxing db architecture.

3 GB physical RAM is not all that much for a SQL machine; our cluster machines have 32 GB of RAM and will use a great deal of that when under stress; Sql Server can make use of a great deal of physical memory in a transient fashion.

You can limit the memory usage. In Sql Server Management Studio, right-click on the server node and select Properties. Memory is the 2nd page, and you can set a minimum and maximum there. This is the same in Sql Server 2005 and Sql Server 2008. You'll need the serveradmin role or above to manage this setting, if I recall correctly.

share|improve this answer
Thanks very much! – Michel Aug 19 '10 at 12:17

it dosent sound like a lot to me. 3GB sounds fairly low for a database machine. Im not a DBA but as far as i know every database machine ive come into contact with was operating with 8gb +

I believe you can limit the memory sqlserver uses (here ) but i wouldnt do that if possible as it'll cause performance slowdowns.

share|improve this answer
+1 for the comment – Michel Aug 19 '10 at 12:18
  • Yes, it is possibl. Check the server properties, you can set limits for SQL Server usage.

  • SSQL Server by edefault uses as much memory as makes sense - for IO caching. It know servers using in excess of 64gb. Ultimately, it depends on the database you have.

  • 1GB is not exactly a lot.

share|improve this answer
+1 for the comment on the 1GB – Michel Aug 19 '10 at 12:17

Your Answer


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.