How much of memory is too much for SQL on 64 bit

We want to move to a 64 bit platform .
First of all I would like to know if there are any cons w/ 64 bit. I would
consider moving to SQL 2005
And second, how much of RAM do you use on such systems ? I dont want to buy
a lot. Would 32 GB or 64 GB be a good start ?Hi
As far as performance you can only really tell if you have enough memory if
you benchmark the application. As this is an existing platform you may want
to take the current amount as a guide if you are not having problems with the
current level of memory, but make sure that you allow for expansion and don't
use up all the available slots (you may want to use a few slots as you can!)
Make sure that you buy as system that satisfies the 64 bit requirements in
http://www.microsoft.com/sql/editions/enterprise/sysreqs.mspx
You should analyse you current design and make sure that you are not limited
by other factors such as hard disc capacity or performance. Make sure that
you buy a sufficiently flexible system so that you can place your database
files in such a way that it will maximise I/O as well have sufficient
capacity for future expansion. Also make sure that you have sufficient
spindles to separate tempdb, the system databases, OS and pagefile etc.
John
"Hassan" wrote:
> We want to move to a 64 bit platform .
> First of all I would like to know if there are any cons w/ 64 bit. I would
> consider moving to SQL 2005
> And second, how much of RAM do you use on such systems ? I dont want to buy
> a lot. Would 32 GB or 64 GB be a good start ?
>
>
>