Posted by Erland Sommarskog on 03/10/06 01:13

IM (ian@ianmurphy.freeserve.co.uk) writes:
> I have recently implemented a SQL 2005 cluster using SQL 2005 Standard
> on Windows 2003 Enterprise edition.
>
> Both nodes have 4GB of RAM and according to the datasheet, SQL 2005
> Standard can support the OS maximum memory amount and Win2K3 Ent
> Edition can support 64GB!
>
> However, in Enterprise Manager, if I go to the "Memory" tab of the
> instance properties I can't increase the memory beyond 2147483647
> (which I assume is around 2GB).

No, that is a little over 2TB, as the unit of the parameter is MB
(or rather 2^20 bytes, I guess).




--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]