• ESAT ERKEC (12/5/2012)


    Task Manager -> Resource Monitor ->Disk-> Filter the sql server.exe and then look at the ratio can you see mdf and ldf file of mirror db....

    for windows 2008 server

    Yep had a look at that sqlservr.exe is at the top writing to the mirrorDB.mdf 400,000 - 1,296,531 Write(B/Sec)

    Followed by the log file writes around 24,104 (B/Sec)