According to Windows Server Division WebLog the Service Pack 2 for Windows 2003 will improve SQL Server 2005 performance by introducing some changes in Winsock API. However you won’t notice the change unless you have a server with 8 or more CPUs and multiple NICs.

 

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