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?