Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

Michel

share|improve this question
add comment

3 Answers

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
add comment
  • 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
add comment

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 http://www.teratrax.com/articles/sp_configure_max_memory.html ) 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
add comment

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.