Mirroring and performance

  • I am thinking about having servers mirror eachother.

    The main server would have a dedicated machine to be it's mirror, but some of the other machines could server as mirrors for eachother, i.e., server A is a mirror for B, while B is a mirror for A, etc.

    would this impact performance of the main functions of these machines as database servers?

    I know this is a bit of an open-ended question, but any suggestions towards what I should  think about regarding this is greatly appreciated.

     

    Ed

  • This was removed by the editor as SPAM

  • You are probably talking about database mirroring ? First , they cannot mirror each other. Only one server can be principal, while another is a mirror.

    Answering to your question, it depends on what kind of mirroring you will choose. With synchronous mirroring mode, you can expect some impact on performace, since your principal server will have to wait for transaction acknowlegment from a mirror server. In asynchronous mode, your principal server does not have to wait for it, therefore this mode is potentially faster, but in this case you are risking that the two databases will be out of sync.

     

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply