Home Forums SQL Server 2008 SQL Server 2008 High Availability Mirroring restore rate very low (< 5 MB/sec) - database mirror stuck in "synchronizing" state for several hrs RE: Mirroring restore rate very low (< 5 MB/sec) - database mirror stuck in "synchronizing" state for several hrs

  • Could the slow restore rate be caused by high file fragmentation on the mirror server?

    Perhaps we are due for a file defrag outage.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]