로그인
 
홈라이브러리학습다운로드지원커뮤니티포럼
Resources for IT Professionals >
> 
> 
Failover on mirroring

Answered Failover on mirroring

  • 2012년 5월 4일 금요일 오전 11:23
     
     
    로그인하여 투표
    0

    Hi all,

    I have one question, we have done manual failover on database mirroring but it is taking 45 minutes to do failover. Finally failover happend so what's the problem taken more time for failover? Can any one explain it?

    Thanks,

    Raveendra

    Raveendra

     

모든 응답

  • 2012년 5월 4일 금요일 오전 11:28
     
     
    로그인하여 투표
    0

    Hi,

    May be latency issue or network related issue...

    Thanks&Regards Siva G

     
  • 2012년 5월 4일 금요일 오후 9:57
     
     
    로그인하여 투표
    0

    Hi,

    This link should give you an insight into the failover process and may help you identify the cause of the delay you're experiencing http://technet.microsoft.com/en-us/library/ms187465.aspx

     
  • 2012년 5월 7일 월요일 오전 6:11
     
     답변됨
    로그인하여 투표
    0
    My tip would be that you have a large number of VLFs in your database. Could you run a DBCC LOGINFO on the DB and tell us how many rows that returns?
     
  • 2012년 5월 11일 금요일 오후 1:28
     
     답변됨
    로그인하여 투표
    0
    I agree with the above comment about the VLF's, you should look at your autogrowth settings and check the number of VLF's to a reasonable amount.  Also look at the size of your transaction log and the synchronization state of the databases at failover time, if they were synchronizing and not synchronized that could also potentially be an issue


    Convert DTS to SSIS | Document SSIS | 30+ SSIS Tasks | Real-time SSIS Monitoring | Quick Starts | BI Blitz

     
  • 2012년 5월 12일 토요일 오전 7:25
     
     
    로그인하여 투표
    0

    Hi Lucifer,

    This is one of the interview question. I had face one of the interview, while interviewer raised this question.Thanks for Quick Response.

    Raveendra