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

  • darrenstokes (2/18/2013)


    Also checked disks and only seeing 9MB/s writing to the disks, and they're capable of much more obviously.

    Are they? Right now? How do you know?

    Run a quick benchmark locally and across the purported gigabit link both - SQLIO is my favorite quick tool for that, but a basic file copy will work, too. Do it both ways, just in case.

    Note that when a disk controller loses its cache, or its battery (which almost always then disabled the cache), you can see a sudden dramatic drop in write performance.

    If nothing else, get the HW folks to run online or offline diagnostics on both ends, the end that's being written to first.