how mucn RAM can SQL on Win2K3 EE support ?

How much RAM can SQL 2K EE on Win2K3 support ?64GB
See http://www.microsoft.com/sql/evalua...ew/default.mspx
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Jim wrote:

>How much RAM can SQL 2K EE on Win2K3 support ?
>
>|||Yes. 64GB using PAE and AWE. If lot of memory is what you're after and you
haven't purchased yet, use 64 bit hardware and SQL Server instead. Your lim
it then will be 512GB and all of it will be directly accessible. Anyone usin
g more than about 16GB of RAM should consider moving to 64 bit. I mention 1
6GB as the cutoff because that's the limit of using the /3GB switch.
Danny
"Mike Hodgson" <mike.hodgson@.mallesons.nospam.com> wrote in message news:ubc
nS$NZFHA.1040@.TK2MSFTNGP10.phx.gbl...
64GB
See http://www.microsoft.com/sql/evalua...ew/default.mspx
mike hodgson | database administrator | mallesons stephen jaques
T +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907
E mailto:mike.hodgson@.mallesons.nospam.com | W http://www.mallesons.com
Jim wrote:
How much RAM can SQL 2K EE on Win2K3 support ?|||Read it again guys; there are caveats. It is 32 GB on the 32-bit version
and 64 GB on the 64-bit version. On Datacenter Edition, it is 64 GB and 512
GB for 32 and 64-bit, respectively.
Well, that's how it use to read, now it looks like both the EE and DE at
64-bit support up to 1 TB of ram.
x" target="_blank">http://www.microsoft.com/windowsser...ns.msp
x
Sincerely,
Anthony Thomas
"Danny" <someone@.nowhere.com> wrote in message
news:V5Fme.6749$m%3.1993@.trnddc02...
Yes. 64GB using PAE and AWE. If lot of memory is what you're after and you
haven't purchased yet, use 64 bit hardware and SQL Server instead. Your
limit then will be 512GB and all of it will be directly accessible. Anyone
using more than about 16GB of RAM should consider moving to 64 bit. I
mention 16GB as the cutoff because that's the limit of using the /3GB
switch.
Danny
"Mike Hodgson" <mike.hodgson@.mallesons.nospam.com> wrote in message
news:ubcnS$NZFHA.1040@.TK2MSFTNGP10.phx.gbl...
64GB
See http://www.microsoft.com/sql/evalua...ew/default.mspx
mike hodgson | database administrator | mallesons stephen jaques
T +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907
E mailto:mike.hodgson@.mallesons.nospam.com | W http://www.mallesons.com
Jim wrote:
How much RAM can SQL 2K EE on Win2K3 support ?