We copied a database from SQL Server 2005 to SQL Server 2008 R2 on a new server.
On the new server (24 cores, 24 gig memory) simple select statements from my client with SSMS that returns 10000 rows take about 50 seconds. The same query on the old server (1 core) takes less than 1 second. Directly on the new server the query runs
very fast (also less than 1 second).
Execution Plans on both servers are exactly the same.
Client Statistics shows on the old machine under "Client processing time" 656 and on the new server 51018.
The same problem occurs on all other clients and with any other larger query/resultset.
It looks like a network issue. But the new server is located in the same datacenter and has a 1000Mbps network connection.
Any help is greatly appreciated.
View Complete Post