Very slow "Reading Indexes"

mfc2mfc2mfc2mfc2 Posts: 17 Bronze 2
in SQL Compare
Why does my SQL Compare 14.2.9.15508 take multiple minutes to read indexes when comparing two SQL Server 2019 databases? The rest of the process is quick, but reading indexes is painfully slow. I tried the Ignore Indexes option in the settings, but that does not help.
Tagged:
· Share on Twitter

Answers

  • Dan_JDan_J Posts: 459 Silver 2
    Hi @mfc2mfc2

    Thanks for reaching out to us regarding this.

    SQL Compare can spend a lot more time reviewing indexes than on the rest of the comparison process, the time taken can be impacted by the number of dependencies upon them.

    I think it would be worth updating SQL Compare to the latest version (14.4.8) to see if that has a positive impact on the time taken to review/compare the indexes. You can download this version here: https://download.red-gate.com/checkforupdates/SQLCompare/SQLCompare_14.4.8.17007.exe 

    I hope this helps, however please don't hesitate in reaching out to us again if you require any further assistance on this.
    Kind regards

    Dan Jary | Redgate Software
    Have you visited our Help Center?
    · Share on Twitter
Sign In or Register to comment.