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 manager.
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:
> > 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
>
>

No comments:

Post a Comment