Performance problem database with many tables

timojanssentimojanssen Posts: 4
edited December 18, 2009 12:56PM in SQL Data Compare Previous Versions
We have some databases with many tables. When comparing this database with a backup, it takes forever to retrieve the schema.
I think it should start with comparing no tables, so you can select the comparison tables/views yourself.
I am waiting for 45 minutes now, and nothing happens ('Retrieving schema / Registering database 0%').
And this is on a two quadcore server with 10 Gb of memory and Raid 5 disks.
· Share on Twitter

Comments

  • timojanssentimojanssen Posts: 4
    After some time the GUI just exits with no message or event.
    I will try the commandline version now in which I will only include one table.
    · Share on Twitter
  • timojanssentimojanssen Posts: 4
    The commandline version also quits after some time without message or eventlog. It was busy 'registering databases' for some time.
    · Share on Twitter
  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi Timo,

    Unfortunately, the backup reader's performance is nowhere near what you get in SQL Server because it dumps pages and access them sequentially whereas SQL Server can randomly hit pages fast because it has a highly optimized database engine.

    If you compare only one table in the command-line application of Data Compare, then you still have to register the entire schemata of both databases.

    If this situation is not workable for you, you may want to just restore the backup to a test server and compare the live databases. The backup reader is mainly for when it's just to inconvenient to restore the databases. Sorry for the inconvenience.
    · Share on Twitter
Sign In or Register to comment.