Indeed, get as much RAM as you can into the system.  Bear in mind however, that if you are using SQL Server 2000 Standard that even if you put 10GB into the box, it can only ever use 2GB leaving the remainder for the O/S – it will never use any more than 2GB.

 

SQL Server 2005 does not have this limitation.

 

N

 

 

 


From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Coughlin
Sent: 04 April 2006 01:04
To: [email protected]
Subject: [farcry-dev] Re: Custom rules

 

Rachel,

 

> …if anyone has any add'l performacing tuning tips for Farcry (other than caching which seems to help a lot) I'm all ears!

 

With the larger sites I have deployed I have found one common requirement repeatedly.  Because you are now dealing with a database driven website the DB is doing a lot of the work.  My clients (so far) are using MSSQL and I have found that the need for RAM is always the case (especially if your client insists on running the SQL server on the same box as CF).  Fortunately RAM is one of the cheaper hardware requirements these days.  Also, if you plan to cache a lot (which is suggested), you’ll need RAM for that on the CF box (again, one of the cheaper hardware requirements).

 

Every FarCry site I’ve launched has been on multiprocessor servers (usually XEON).  But to be honest, with proper caching techniques I’ve rarely seen the need for the extra CPU horsepower (depending on any 3rd-party apps/resources required on the box or website).

 

Bottom line: RAM.  For most production servers I usually give SQL 4 GB.  I’ve tried using 2GB on a few servers (and that may be plenty ofr your setup), but you really need to watch the system resources.  One SQL server I had running decided to lock-up after a couple months when it couldn’t get any more RAM (that site has thousands of pages and requires about 1.8GB RAM just for SQL).  Rebooting temporarily fixed the problem until we increased the RAM to 4GB (3GB would probably have been enough, but we played it safe).

 

Hope that helps,

 

Jeff Coughlin

Web Application Developer

http://www.jeffcoughlin.com



--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "farcry-dev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/farcry-dev
-~----------~----~----~----~------~----~------~--~---

This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com


Reply via email to