Posted by IM on 03/10/06 11:36

Erland Sommarskog wrote:
> 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

Erland, your're absolutely right. I am either blind or stupid (or
possibly a combination of both)!

Thanks for pointing this out :-) think I'll go back to washing dishes
or something...

Cheers,

Ian

[Back to original message]