Re: 4 Gb RAM in SQL 2000 Standard
From: Mike Epprecht \(SQL MVP\) (mike_at_epprecht.net)
Date: 12/01/04
- Next message: Mike Epprecht \(SQL MVP\): "Re: SQL2000 SP4"
- Previous message: Mike Epprecht \(SQL MVP\): "Re: Cannot restore database from a remote server"
- In reply to: cathedr_at_wa.state.gov: "4 Gb RAM in SQL 2000 Standard"
- Next in thread: Andrew J. Kelly: "Re: 4 Gb RAM in SQL 2000 Standard"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 1 Dec 2004 01:03:51 +0100
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?
- Next message: Mike Epprecht \(SQL MVP\): "Re: SQL2000 SP4"
- Previous message: Mike Epprecht \(SQL MVP\): "Re: Cannot restore database from a remote server"
- In reply to: cathedr_at_wa.state.gov: "4 Gb RAM in SQL 2000 Standard"
- Next in thread: Andrew J. Kelly: "Re: 4 Gb RAM in SQL 2000 Standard"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
