We just bought a new server to upgrade our SQL server. The new server has 32GB ram and 4 Xeon processors running Windows Enterprise Server 2003 and SQL 2000 Enterprise 8.00.2040 (sp4) with AWE hotfix applied. AWE is enabled on SQL 2000, Boot.ini includes the following options: multi(0)disk(0)rdisk(0)partition(1)WINDOWS="Windows Server 2003, Enterprise" /noexecute=optout /fastdetect /PAE SQL server came up and seemed to be running fine, configured to use all 8 processors, use as much memory as it wants and boost priority on Windows. Under load, it does not appear to be using all available resources. Processor traces show that it is using 4 of the 8 virtual processors (at about 25-40%), with the other 4 hanging out around 2-5%. The prior server was also a quad Xeon and did not have this issue. All 8 processors seemed to be the same on the traces. Also, both Target Server Memory and Total Server Memory on the server traces are hanging around at 1668272 or thereabouts, with Task Manager showing about 1.7 GB being used. The load on the server, which handles about a dozen databases, should be plenty to keep most of the 32GB of ram busy, but the traces seem to indicate that the server does not see the extra RAM. In short, it seems to be acting as if it is SQL 2000 Standard instead of SQL 2000 Enterprise, with no AWE enabled.