I am using Windows 2003 Enterprise Edition, SQLServer 2000 Enterprise Edition (sp3a) + hotfix Q834628. I have a 8 processor machine. I want to increase my memory from 8GB to 16GB, in order to boost performance.

Anyone have any tips/tricks/advice/pitfalls on this configuration?

Specifically, I am wondering about:

1) any special registry settings? does the kernel need any special additions/configurations?

2) what should be the 'max memory' setting

3) what should be the mem-to-leave setting

4) what should the paging file size be?