In addition, your operating system will need to be Windows 2000 Enterprise Edition or Windows 2003 Standard or Enterprise edition. If your OS is one of these, enable PAE using the /PAE switch in the boot.ini file. Changes to the boot.ini file will require that the server be rebooted to take effect. You should read Microsoft article, How to edit the Boot.ini file in Windows XP before editing the boot.ini file.
Dig Deeper on Microsoft SQL Server Performance Monitoring and Tuning
Related Q&A from Denny Cherry
Find out where to look for the current amount of SQL Server database disk space being used in your environment. Continue Reading
If you have exceptionally large SQL Server databases, refer to these best practices for proper database maintenance to steer clear of a website '... Continue Reading
Troubleshoot long running stored procedures with SQL Server Profiler by adding events to find the command with high run time. Continue Reading