SQL Server AlwaysOn is the new high availability and disaster recovery solution of the SQL Server “Denali”. “Using AlwaysOn businesses can achieve increased application availability for their mission critical applications and get higher returns on their high availability investments through better utilization of hardware resources,” explained Balasubramanian.
AlwaysOn also increases productivity and lowers TCO by greatly simplifying high availability deployment and management.
Key Features of AlwaysOn Availability Group
- Multi database failover
- Multiple secondaries (A secondary is conceptually similar to a Mirror in Database Mirroring)
- Max of 4 secondaries
- Support for 2 synchronous secondaries for additional data protection
- Readable secondary
- Secondary backup
- DMV, Perfmon Counter, Xevents etc…
Key Features of AlwaysOn Failover Cluster Instance
- Native support for multi-site clustering across subnets enable DR using failover cluster instances
- Flexible Failover Policy
- Providing new failure detection mechanism using sp_server_diagnostics
- Customer Configurable failure condition level for more granular control on failover
- Better diagnostics
Database Availability and Instance Availability using AlwaysOn
- AlwaysOn Availability Group is the new feature in SQL Server AlwaysOn that provides availability forapplication database(s). Availability Group provides a rich set of options that gives the flexibility to configure a high availability environment that can meet the SLA’s of the various applications in your environment. The feature also comes with a set of options that allows utilization of your secondaries. Apart from these options there is complete integration with management studio and Powershell that makes deployment and management of Availability Group extremely simple.
- AlwaysOn Failover Cluster Instance enhances the existing SQL Server Failover Clustering feature and provides availability for the entire instance. AlwaysOn provides a richer set of capabilities that will increase instance availability and addresses a number of existing pain points.
For more information on AlwaysOn please go to the AlwaysOn Resource Center.