Wednesday, March 28, 2012

More Memory

Is there any way to get Standard SQL Server 2000 to use more than 2GB of
memory? I am running on a 2003 standard server w/the 3GB switch in the
boot.ini, but SQL still appears to only use 2GB of memory in the task manage
r.
Thanks> Is there any way to get Standard SQL Server 2000 to use more than 2GB of
> memory?
No. You need to step up to Enterprise Edition to use more than 2GB. See
'Maximum Capacity Specifications' in the Books Online for details.
Hope this helps.
Dan Guzman
SQL Server MVP
"Matt L." <Matt L.@.discussions.microsoft.com> wrote in message
news:6795FFF1-A0DB-40CB-82C5-35D3473FFB42@.microsoft.com...
> Is there any way to get Standard SQL Server 2000 to use more than 2GB of
> memory? I am running on a 2003 standard server w/the 3GB switch in the
> boot.ini, but SQL still appears to only use 2GB of memory in the task
> manager.
> Thanks|||OK, Thanks Dan
"Dan Guzman" wrote:

> No. You need to step up to Enterprise Edition to use more than 2GB. See
> 'Maximum Capacity Specifications' in the Books Online for details.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Matt L." <Matt L.@.discussions.microsoft.com> wrote in message
> news:6795FFF1-A0DB-40CB-82C5-35D3473FFB42@.microsoft.com...
>
>

No comments:

Post a Comment