Memory limitations, 2005 Standard

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,

IanIM (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/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||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/pr...oads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodin...ions/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