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

What is the risk involved in running on 91% RAM usage on Windows Server 2003 32 SP2 and SQL Server 2005 in terms of SQL Server performance?

Server has 3GB and mostly sits at around 80% mark with peaks at 91% RAM usage.

Also what are performance prospects for installing SQL Server 2008 R2 on such a system with SiteCore 6.4 CMS?

share|improve this question
    
Doe yout boot.ini have the /3GB switch in it? –  KCotreau May 27 '11 at 1:18
    
Memory isn't ususally an issue in windows. See serverfault.com/questions/74822/… –  Jim B May 27 '11 at 3:03

1 Answer 1

There isn't much risk in your scenario. SQL will always take all the memory it can get, and scale back when the OS needs more. You could probably throw another 1GB stick in that box, and get it up to 3.5 usable, just to squeeze a bit more out of it.

Since Server 2008 R2 is 64 bit only, your memory limit is really high, just make sure you are installing SQL 64 bit as well to take advantage of it.

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.