I have inherited (lucky me) a very old accounting system which will be retired over the next 18 months. In the meantime, for various reasons, I need to upgrade the DB server.
It's currently running SQL Server 2000 Sp4 Enterprise on Windows 2000 Advanced Server.
The only supported OS I can get to without upgrading the whole application (too costly) is Windows 2003 x64.
I plan to put it on a VMware server, Windows 2003 x64 Enterprise Edition, with SQL Server 2000 SP4 Enterprise Edition x86. The virtual server will have 8GB Ram allocated to it and 4 vCPUs.
Is Sql Server 2000 x86 on Win 2k3 x64able to access the full 8GB of the OS (using PAE or similar?)