Introducing SQL Server code-named "Denali" AlwaysOn

  • Article

Welcome to the official Microsoft SQL Server team blog for SQL Server AlwaysOn. As a team we are excited to share our knowledge with you and more importantly we are keen to get valuable feedback from you about the new high availability and disaster recovery solution for SQL Server, AlwaysOn.

Let us get started by answering the fundamental question, What is SQL Server AlwaysOn?

SQL Server AlwaysOn is the new high availability and disaster recovery solution for SQL Server. Using AlwaysOn businesses can achieve increased application availability for their mission critical applications and get higher returns on their high availability investments through better utlization of hardware resources. AlwaysOn also increases productivity and lowers TCO by greatly simplifying high availability deployment and management.

The new solution will be available in the next release of SQL Server, code named Denali. The initial feature set of AlwaysOn is now available in CTP1 that was just released during the SQL PASS 2010 conference. The CTP can be downloaded here.

Database Availability and Instance Availability using AlwaysOn

The key aspect of AlwaysOn is that it provides you with the flexibility to configure high availability and disaster recovery for your application databases and\or for the entire instance.

  • AlwaysOn Availability Group is the new feature in SQL Server AlwaysOn that provides availability for application 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.

An important point to note is that AlwaysOn is built on the robust and reliable Windows Server Failover Cluster (WSFC) platform and is required for enabling Availability Group for database level availability and for creating a failover cluster instance for instance level availability. We will talk more about this dependency in the future blogs.

For getting started with AlwaysOn using CTP1, check the new AlwaysOn resource site. Note that you will see a lot of reference to HADR in the CTP1 download and documentation. This is our internal reference while the features are in development.