How can we help you today? How can we help you today?

Painful performance - SQL 2000 Comparison

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
Hillsman
0

Comments

1 comment

Sort by
  • Chris Auckland
    Thanks for your post.

    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?
    Chris Auckland
    0

Add comment

Please sign in to leave a comment.