Re: SQL 2000 memory in W2K3

Tech-Archive recommends: Fix windows errors by optimizing your registry

AP wrote:
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

Right, I missed the fact that it is EE.........

--

Regards,
Hank Arnold
Microsoft MVP
Windows Server - Directory Services
.

Relevant Pages

  • Re: 4GB of RAM tunning in windows xp professional xp sp2 with 32bi
    ... The host or underlying operating system (Windows XP) cannot fully access all the installed RAM so in turn the Virtual Machine and any software that it runs will not be able to access all the RAM. ... If VMware tells you to use the /3gb switch then use it, it will help by making more Virtual Address Space available to the application and in turn the Virtual Memory Manager will be able to map more of the VAS to physical memory addresses, but that will still not allow the use of the unavailable RAM, and it does not guarantee that the full 3GB of VAS will be mapped to the RAM, it will be mapped to available RAM and or the pagefile, it depends on what the kernel mode processes and non pagegable code needs for its use. ... And finally, Microsoft Office SharePoint Server requires Microsoft Windows Server 2003 Standard Edition, Windows Server 2003 Enterprise Edition, Windows Server 2003 Datacenter Edition or Windows Server 2003 Web Edition to run. ...
    (microsoft.public.windowsxp.general)
  • Re: Cant believe it, but I need help.
    ... Error message when a Delayed Write Failure event is reported in Windows Server ... 512x4 DDR RAM cards ...
    (microsoft.public.windowsxp.hardware)
  • RE: More then 4GB of RAM on Win2k3 SP1 on Dell Poweredge 2800
    ... The maximum quantity of RAM that can be supported by Windows 2003 is up to ... Windows Server 2003 Enterprise Edition, ... Microsoft Global Technical Support Center ...
    (microsoft.public.windows.server.general)
  • Re: Active/Active Clustering - Help!
    ... A/A is not a SQL term, but it is a Windows Server 2003 Clustering term. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SMS 2003 Setup Error
    ... > Integrated Windows Authentication (SQL) ... > access the Windows server." ...
    (microsoft.public.sms.setup)