The Windows XP configuration is a generic computer with a Pentium D 2.8GHz, 1GB of RAM, with Microsoft SQL Server 2008 (RTM) – 10.0.1600.22 (Build 3790: Service Pack 2)
The Windows Server 2003R2 is a Dell PowerEdge 2950, with a Pentium Xeon quadcore 2.0GHz, 14GB of RAM, the same SQL Server than previous one.
The database is 4GB, running an stored procedure.
The elapsed time to complete the process is:
XP = 14 min.
2k3 = 38 min.
In both cases the SQL server is configure to use all cores. There is no other task running.
How can we increase performance in the Server to out perform the XP box?
Best Answer
What do you have your max degrees of parallelism set to on the server? Have you tried tweaking that for the query in question?
http://support.microsoft.com/default.aspx/kb/329204
When you run the query on the quad-core box, do you see all the cores light up busy?