|Subject:||Moving database decrease performance|
|Posted by:||simon (zupan.n…@gmail.com)|
|Date:||Tue, 14 Dec 2010|
I have moved database from one SQL2000 on win server to another
Both SQL serverers have the same settings, same service pack,
On both SQL servers are tempDB, log file and mdf file on separate
The new SQL server is on better computer, has more RAM, beter disks,
stronger proc, but all queries are executing 2 times slower.
I have rebuilded all indexes and statistics and the same result.
What are the steps that I should look for?
Is there some guide for this scenario somewhere on the net?