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,

Ian

.

Relevant Pages

  • Re: Locking pages in memory
    ... So I think the 64-bit Standard does not support locked pages in memory. ... Rick Byham, SQL Server Books Online ...
    (microsoft.public.sqlserver.setup)
  • Re: Benchmark for different edition SQL 2000
    ... Enterprise edition has some distinct features that SE doesn't. ... INF: SQL Server Memory Usage ... Tibor Karaszi, SQL Server MVP ... the memory arrangement is the same between standard and enterprise? ...
    (microsoft.public.sqlserver.server)
  • Re: Benchmark for different edition SQL 2000
    ... > My concern is how to prevent the SQL server that increase the memory usage continuously? ... > Enterprise edition has some distinct features that SE doesn't. ... the memory arrangement is the same between standard and enterprise? ...
    (microsoft.public.sqlserver.server)
  • Re: Memory config - SQL Enterprise running on Windows 2003 Standard Se
    ... Books Online indicates that the Enterprise Edition of SQL Server will run on ... on a Win2k3 Standard box). ... > I have a new server that came with 6GB of memory. ... The OS is Windows 2003 ...
    (microsoft.public.sqlserver.setup)
  • Re: Benchmark for different edition SQL 2000
    ... Please read the links I posted about memory allocation algorithms in SQL Server. ... My concern is how to prevent the SQL server that increase the memory usage continuously? ... Enterprise edition has some distinct features that SE doesn't. ... the memory arrangement is the same between standard and enterprise? ...
    (microsoft.public.sqlserver.server)