SQL 2000 - Rule of thumb for memory requirements?

SQL 2000 - Rule of thumb for memory requirements?

Post by Gav » Fri, 27 Jul 2007 00:59:55


Are there any official documents with a rule of thumb for how much memory a
server should have depending on database size? I've been googling for a
while now don't seem to be able to find any apart from individuals saying
use same amount as the database size, with their example being a 2GB
database with 2GB of RAM. My database is approximately 350GB (actual
data/index not file size) with approx 540 user connections and am wondering
what amount of memory would be best suited to this database.

Gav
 
 
 

SQL 2000 - Rule of thumb for memory requirements?

Post by Andrew J. » Fri, 27 Jul 2007 02:48:13

You can not go just by the size of the db. You have to consider how the
data is used and how much of it is accessed on a regular basis. It is
impossible to tell just from the size alone. You want enough memory to keep
the most accessed data and indexes in cache while still leaving room for
other things such as procedure cache, connection memory etc. While you can
have more memory than you need you are much better off having too much than
not enough. If you need more than 4GB you should consider using X64 or 64
bit OS and Sql Server to maximize memory efficiency.

--
Andrew J. Kelly SQL MVP