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, Contributor
Planning an upgrade to SQL Server 2008? Our expert weighs in on advantages and hardware requirements you should consider before upgrading to SQL ...continue reading
To avoid performance problems when running multiple instances of SQL Server 2005 with Exchange on Windows SBS, refer to these expert best practices.continue reading
After installing SQL Server 2005, the SQL Server tools may not appear in the start menu. Our expert explains how to troubleshoot this problem.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.