Max Memory SQL2K EE on W2K3 EE

This is what I have
Windows Server 2003 Enterprise Edition (x86)
SQL Server 2000 Enterprise Edition (x86)
What I'm trying to clarify is if I have a W2K3 EE system with 32GB of RAM
can a single instanace of SQL2K EE access the entire 32GB
or
Will the single instance only access 8GB and therefore only if I had 4
instances would SQL Server use 32GB
Thanks,
Paul
SP3 and higher will address 32 GB of RAM on W2k3EE. I wouldn't set total
SQL memory for all instances higher than 28GB on such a system. Setting
memory higher can starve necessary OS functions like AWE mapping which will
kill performance and stability
GNH
"Paul Ward" <Paul Ward@.discussions.microsoft.com> wrote in message
news:79DC5A4B-BE32-4770-861F-ACFD2D08DB00@.microsoft.com...
> This is what I have
> Windows Server 2003 Enterprise Edition (x86)
> SQL Server 2000 Enterprise Edition (x86)
>
> What I'm trying to clarify is if I have a W2K3 EE system with 32GB of RAM
> can a single instanace of SQL2K EE access the entire 32GB
> or
> Will the single instance only access 8GB and therefore only if I had 4
> instances would SQL Server use 32GB
> Thanks,
> Paul
|||Thanks Geoff.
I've looked through the release notes for SP3 and can't find any reference
to this.
Have you seen this documented somewhere or is your answer based on a system
you have worked with?
"Geoff N. Hiten" wrote:

> SP3 and higher will address 32 GB of RAM on W2k3EE. I wouldn't set total
> SQL memory for all instances higher than 28GB on such a system. Setting
> memory higher can starve necessary OS functions like AWE mapping which will
> kill performance and stability
> GNH
>
> "Paul Ward" <Paul Ward@.discussions.microsoft.com> wrote in message
> news:79DC5A4B-BE32-4770-861F-ACFD2D08DB00@.microsoft.com...
>
|||Is a Microsoft KB article good enough?
How to configure SQL Server to use more than 2 GB of physical memory
http://support.microsoft.com/kb/274750
Click on the scrolldown link to Windows 2000 Advanced Server or Windows 2000
Datacenter or Windows Server 2003
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Paul Ward" <PaulWard@.discussions.microsoft.com> wrote in message
news:43B4240B-1E41-4BA3-B068-CF048598E1AD@.microsoft.com...[vbcol=seagreen]
> Thanks Geoff.
> I've looked through the release notes for SP3 and can't find any reference
> to this.
> Have you seen this documented somewhere or is your answer based on a
> system
> you have worked with?
> "Geoff N. Hiten" wrote:
|||I've seen this before and although it states that W2K3 EE supports 32GB using
PAE it doesn't actually make it clear that SQL2K EE can use (the majority) of
this.
Have you been involved with a system running W2K3 EE and SQL2K EE with a
large amount of RAM?
"Geoff N. Hiten" wrote:

> Is a Microsoft KB article good enough?
> How to configure SQL Server to use more than 2 GB of physical memory
> http://support.microsoft.com/kb/274750
> Click on the scrolldown link to Windows 2000 Advanced Server or Windows 2000
> Datacenter or Windows Server 2003
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Paul Ward" <PaulWard@.discussions.microsoft.com> wrote in message
> news:43B4240B-1E41-4BA3-B068-CF048598E1AD@.microsoft.com...
>
|||Yes. I have built a system with 32GB of physical RAM , W2K3EE and SQL2K EE,
It happened to be a four-node cluster with 8 procs per node, just to make it
more complex. So much of my advice in this area is from hard-earned
direct knowledge.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Paul Ward" <PaulWard@.discussions.microsoft.com> wrote in message
news:4B55AA08-7B48-4221-BBA3-8B0D4AFA7906@.microsoft.com...[vbcol=seagreen]
> I've seen this before and although it states that W2K3 EE supports 32GB
> using
> PAE it doesn't actually make it clear that SQL2K EE can use (the majority)
> of
> this.
> Have you been involved with a system running W2K3 EE and SQL2K EE with a
> large amount of RAM?
>
> "Geoff N. Hiten" wrote:
|||Thanks for help and sharing your knowledge on this
"Geoff N. Hiten" wrote:

> Yes. I have built a system with 32GB of physical RAM , W2K3EE and SQL2K EE,
> It happened to be a four-node cluster with 8 procs per node, just to make it
> more complex. So much of my advice in this area is from hard-earned
> direct knowledge.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Paul Ward" <PaulWard@.discussions.microsoft.com> wrote in message
> news:4B55AA08-7B48-4221-BBA3-8B0D4AFA7906@.microsoft.com...
>
sql