THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Kevin Kline

SQL Server Performance Improvements on Windows 2003 SP2

SQL Server MVP Aaron Bertran recently asked for elaboration on the comments posted here:

http://blogs.technet.com/windowsserver/archive/2006/08/01/444365.aspx  

Specifically, "Performance improvements for SQL Server Service Pack 2 provides performance improvement for SQL Server 2005 under intensive workloads . These improvements are installed by default upon Service Pack 2 installation."

SQL Server PM Umachandar Jayachandran related that the improvements are related to winsock API.  The change in the winsock API is more perceivable on SQL workloads running with 8 CPUs + multiple NICs.  For example, you may notice it when running a high-end SAP load.  It will not be noticeable/measurable on other configurations.  Note that you'll need both Windows 2003 and SQL Server 2005 SP2 or higher also.

Thanks Aaron and Umachandar!

-Kevin

Published Wednesday, December 20, 2006 4:06 PM by KKline

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

No Comments

Leave a Comment

(required) 
(required) 
Submit

About KKline

Kevin Kline is a well-known database industry expert, author, and speaker. Kevin is a long-time Microsoft MVP and was one of the founders of PASS, www.sqlpass.org.

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement