Solutions / Advanced Solutions / High Availability /
MSSQL HA Solutions
MSSQL High Availability
High availability plays a very key role for mission critical databases to maintain the up-time of the business applications. MSSQL Enterprise Edition comes with inbuilt features that enables to build
High Availability with additional costs for hardware/storage/Software for the customers.
MSSQL provides HA in Shared and Shared Nothing architectures to remove off single point of failures having no downtime and data loss.
MS SQL Cost Factors:
- MSSQL Enterprise Edition software licensing/Support for all HA nodes – @as per vendor costing
- Additional shared storage required – @as per vendor costing
- MS SQL – DR Enterprise Edition software licensing/support (optional) – @as per the vendor costing
- Auto fail/Switch over
- The Data resides on its local disks or shared based on the selected architecture
- Second node resides on idle (unusable) state in Shared Architecture until primary fails
- Primary Node operates in RW mode and Secondary node resides in READ mode for
- Non shared Architecture
- No adequate Hardware resources utilization for secondary shared node
- MS SQL DBA resource costs. @higher costs
