Hi all,

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).

I don't have AWE enabled but am unsure as to the ramifications of this.

Any advice anyone could provide would be greatly appreciated.

Many thanks,

Ian

IM (ian (AT) ianmurphy (DOT) freeserve.co.uk) writes:
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 (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

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