Re: SQL 2000 memory in W2K3
- From: "Tibor Karaszi" <tibor_please.no.email_karaszi@xxxxxxxxxxxxxxxxxx>
- Date: Fri, 14 Sep 2007 16:47:45 +0200
Yep. EE can use up to 64 GB (limited by OS and HW). SE is limited to 2GB.
2005 is another story.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"AP" <AP@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:EF425ECB-7690-4730-81A3-2323F6F06ACD@xxxxxxxxxxxxxxxx
Hank,
The previous reply from Ekrem indicates that SQL 2000 can use more than 2 GB
of ram.
AP
"Hank Arnold (MVP)" wrote:
AP wrote:
> Just set up a new Dual Xeon Dual Core with 8 GB of physical ram. It is
> running on Windows 2003 Enterprise Edition, and SQL 2000 Enterprise Edition.
> The setup put the /PAE switch in the boot.ini. It only looks like the server
> is using about 1.7 GB of ram at the moment. I have not changed any settings
> from the standard CD install. How can I be sure that the server will utilize
> more of the ram when it requires it? It is not going to be running anything
> else other than the SQL.
>
> Thanks
IIRC, SQL2000 can't use more than 2GB RAM.....
--
Regards,
Hank Arnold
Microsoft MVP
Windows Server - Directory Services
.
- References:
- Re: SQL 2000 memory in W2K3
- From: Hank Arnold (MVP)
- Re: SQL 2000 memory in W2K3
- Prev by Date: Re: DB Maintenance?
- Next by Date: Re: SQL 2000 memory in W2K3
- Previous by thread: Re: SQL 2000 memory in W2K3
- Next by thread: Re: SQL 2000 memory in W2K3
- Index(es):
Relevant Pages
|
Loading
