Painful performance - SQL 2000 Comparison
Hillsman
Posts: 3
One of our SQL 2000 Servers was replaced over the weekend - I wasn't involved in the replacement, though as far as I was aware, the movement of SQL databases was a little unorthodox - The system databases were overwritten with copies from the original server; all other databases were then picked up once the database service was restarted (I would've used scripts to first backup, then restore all databases)
Anyway, since this process was completed, any comparison against a database on this server either takes 45+ mins or doesn't finish at all (database is about 115MB - largest table stores 150k rows)
Any ideas how I can speed this up?
Many thanks,
Hillsman
Anyway, since this process was completed, any comparison against a database on this server either takes 45+ mins or doesn't finish at all (database is about 115MB - largest table stores 150k rows)
Any ideas how I can speed this up?
Many thanks,
Hillsman
Comments
There is not actually much you can do to speed up the performance of SQL Data Compare, you might be interested in looking at the following article, but I'm not sure it will be much help in your situation.
http://www.red-gate.com/supportcenter/C ... 000166.htm
Does the new server have particularly different hardware or SQL Server version to the old one?