Interview Questions
1. What is High Availability operating mode?
It consist of the Principal, Witness and Mirror in synchronous communication. In this mode SQL server ensures that each
transaction that is committed on the Principal is also committed in the Mirror prior to continuing with next transactional
operation in the principal. The cost of this configuration is high as Witness is required. If the network does not have the
bandwidth, a bottleneck could form causing performance issue in the Principal. If Principal is lost Mirror can automatically take
over.
Submit an interview question
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment