Dear Sir,
Currently, I have a clustered SQL 2000 Server with 16GB ram on each Win2003
instance. I already enabled the AWE and set the max. memory used by SQL
Server at 14GB. But somebody said the max. ram can addressed by SQL Server i
s
less than 14GB actually, is that true? If yes, what is the max. ram can be
addressed by SQL 2000?
Also, I am planning to upgrade the platform to 64-bit Win2003 too, then what
is the max. ram can be addressed by SQL 2000 64-bit version?
Thanks a lot!
From,
HenryThis depends on the SQL Server edition and OS edition used
Windows Server 2003, Standard Edition (32-bit)
SQL Server 2000, Standard Edition (SE) 2GB
SQL Server 2000, Enterprise Edition (EE) 3GB
Windows Server 2003, Enterprise Edition (32-bit)
SQL Server 2000, Standard Edition (SE) 2GB
SQL Server 2000, Enterprise Edition (EE) 32GB
Windows Server 2003, Datacenter Edition (32-bit)
SQL Server 2000, Standard Edition (SE) 2GB
SQL Server 2000, Enterprise Edition (EE) 64GB
Windows Server 2003, Enterprise Edition (64-bit)
SQL Server 2000 EE, 64-bit Edition 64GB
Windows Server 2003, Datacenter Edition (64-bit)
SQL Server 2000 EE, 64-bit Edition 512GB
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright SQLDev.Net 1991-2004 All rights reserved.
"Henry" <Henry@.discussions.microsoft.com> wrote in message
news:D3BFB45F-5B70-4905-A452-5110644C1191@.microsoft.com...
> Dear Sir,
> Currently, I have a clustered SQL 2000 Server with 16GB ram on each
> Win2003
> instance. I already enabled the AWE and set the max. memory used by SQL
> Server at 14GB. But somebody said the max. ram can addressed by SQL Server
> is
> less than 14GB actually, is that true? If yes, what is the max. ram can be
> addressed by SQL 2000?
> Also, I am planning to upgrade the platform to 64-bit Win2003 too, then
> what
> is the max. ram can be addressed by SQL 2000 64-bit version?
> Thanks a lot!
> From,
> Henry
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment