4 Gb RAM in SQL 2000 Standard

I want to run both analysis services and standard relational Db services on
one server with 4 Gb of RAM. I have read that if you want to use more than 2
Gb RAM you should choose the Enterprise version of SQL 2000. I want to know
if that 2 Gb limit is for both analysis and relational combined or whether
the limit is 2 Gb per service.
Can anyone tell me with absolute certainty?
Hi
2Gb is per instance of SQL Server. If you have 4Gb, at most you can use is
3GB (with the /3gb switch in boot.ini)
So in effect, AS and SQL Engine can use 3Gb between them, but one can not
use more than 2Gb.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"cathedr@.wa.state.gov" <cathedrwastategov@.discussions.microsoft.com> wrote
in message news:2F2C975C-3322-41BF-8EB3-C5552A47DB39@.microsoft.com...
> I want to run both analysis services and standard relational Db services
on
> one server with 4 Gb of RAM. I have read that if you want to use more
than 2
> Gb RAM you should choose the Enterprise version of SQL 2000. I want to
know
> if that 2 Gb limit is for both analysis and relational combined or whether
> the limit is 2 Gb per service.
> Can anyone tell me with absolute certainty?
|||With Standard Edition all you can ever use is 2GB per instance, even with
the /3GB. If it were EE then that would be true. But if you only have 4GB
you never want both instances of SQL Server to use all 2GB each. Then you
leave nothing for the OS or any other apps that yo may run and you will
certainly get page swapping at the OS level. SQL Server will dynamically
allocate memory to minimize this but if you fully utilize all the physical
memory for SQL Server you will get swapping at hte OS level.
Andrew J. Kelly SQL MVP
"cathedr@.wa.state.gov" <cathedrwastategov@.discussions.microsoft.com> wrote
in message news:2F2C975C-3322-41BF-8EB3-C5552A47DB39@.microsoft.com...
>I want to run both analysis services and standard relational Db services on
> one server with 4 Gb of RAM. I have read that if you want to use more
> than 2
> Gb RAM you should choose the Enterprise version of SQL 2000. I want to
> know
> if that 2 Gb limit is for both analysis and relational combined or whether
> the limit is 2 Gb per service.
> Can anyone tell me with absolute certainty?