SQL Server 2000 Clustering Gotchas
Part 2 on AWE Memory
- If AWE is enabled, SQL Server cannot use the paging file
- If AWE is enabled, SQL Server will grab all memory it is allowed if the max server memory configuration option is not set. If you accidentally forget to set this, SQL Server will attempt to grab all memory on the server, starving the OS. To rectify this, you will have to shut down SQL Server since the memory comes from a non-pooled region of RAM and is not "interchangeable" with the OS.
- Once max server memory configured, set the working size to 0.
See here from more details!
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx
