SQL Server Operating Systems

Performance Tuning Windows 2003 When Running SQL Server

Should you run SQL Server on NT Server 4.0, Windows 2000, or Windows 2003 for the best performance? Each new version of the Windows operating system offers new performance benefits. While the leap from NT Server 4.0 to Windows 2000 was not large, the leap in performance from Windows 2000 to Windows 2003 is very […]

Performance Windows 98/ME When Running SQL Server

Check to be sure the “Application Performance” for your server is set to “None”. This ensures that any foreground applications you run on your server will not get a higher priority than SQL Server. To find this setting, go to the “Control Panel”, click on the “System” icon, then click on the “Performance” tab. [6.5, […]

Performance Tuning Windows 2000 When Running SQL Server

When running Windows 2000, you will need to ensure that all the hardware you run it on, and their related drivers, have been tested for use with Windows 2000. Using an outdated or buggy driver can wreck havoc with performance. [7.0, 2000, 2005] Updated 11-28-2003 ***** If you want to upgrade a current server running […]