Tuesday, September 19, 2006 9:54 AM
xmldeveloper
SQL Server 2005 performance improvement on Windows 2003 Server SP2
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