Re: SQL 2000 memory in W2K3

Yes, for sure.

--
Ekrem Önsoy



"AP" <AP@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:A3A6EAB7-F94F-4E76-81CD-23AE0E30DBBB@xxxxxxxxxxxxxxxx
Tibor,

However, EE still requires the AWE to be enabled, and the max server memory
to be set, correct?

AP


"Tibor Karaszi" wrote:

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
>>


.

Relevant Pages

  • Re: SQL-SERVER 2005 SP2 und Microsoft Dynamics 5.0 (ehem. Navision
    ... Wert ist immer zwischen 84,7 -99,8 akt. ... es geht darum wieviel % der Daten, die der SQL Server wollte bereits in seinem Workspace waren. ... 16 GB 2 GB RAM ...
    (microsoft.public.de.sqlserver)
  • Re: WSUS
    ... Les Connor [SBS MVP] ... Is your server exhibiting significant performance problems, and if so, how ... SQL Server: ... >No wonder SBS brings servers with 4GB of RAM to their knees. ...
    (microsoft.public.windows.server.sbs)
  • =?Utf-8?Q?Re:_sqlserver.exe_kommt_nicht_=C3=BCb?= =?Utf-8?Q?er_100mb?=
    ... 300ms im RAM gehalten werden. ... Morgen werden wir mehr Speicher einbauen und nochmal die Zeiten auslesen. ... um den Server selbst zu tracen. ... MCTS: Microsoft SQL Server 2005 ...
    (microsoft.public.de.sqlserver)
  • Re: Seems like only 1GB RAM being used even when higher MAX RAM is
    ... It is Sql 200 enterprise, ... Both machines are equipped with 8gb of RAM. ... you said your SQL Server 2000 instance is ... If your SQL Server 2000 is Enterprise Edition and your Windows Server 2003 ...
    (microsoft.public.sqlserver.setup)
  • Re: Alocated Memory Error (SQLSERVR)
    ... but my understanding is that the MSDE instances are designed to ... and you don't want it grabbing all that RAM. ... running but non ever going about 200mb of memory usage. ... Server 2000 SP4, ...
    (microsoft.public.windows.server.sbs)
Loading