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

  • July 21, 2012 at 10:55 pm

    #1515925

    Marios Philippopoulos (7/21/2012)

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

    Perhaps we are due for a file defrag outage.

    No file level fragmentation would cause a slow degradation of performance, not a sudden one.

    My blog: SQL Soldier[/url]
    SQL Server Best Practices:     SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]