sql server (microsoft): Hi,

I've been searching on the net for general recommendations regarding
memory, for quite some time, but without any luck. I am sure there are
some neat formula out there to calculate how much memory a server need
for a particular size of database, but that doesn't help me I would
like to know if there's some general recommendation on how to size a
server's memory based on how large the database is. How much memory
would a 1 TeraByte database be needing, in rough figures? Are we
talking 16 GB? More? Less? Please share your experience =3DD

Thanks in advance,
Bj=F6rn

[quoted text, click to view]


Hi Bjorn,

It's not quite as simple as relating memory size to database size - if
only! I have worked with databases of similar sizes and memory, but
differing performance due to the workloads placed on each.

You need to understand more about what your database is doing. How
much memory is currently available and in use by SQL Server? Is there
much paging? What is the buffer cache hit ratio counter showing? Is
SQL Server set to use all available memory or does it have a
configured maximum value? Are there any other applications consuming
memory? How many concurrent users?

The list of questions could go on and on! My advice would be to get
some baseline information regarding your instance through perfmon
counters and look at the number of transactions being processed, what
kind of transactions.

This is just getting the ball rolling, so to speak...

Good luck!