We are excited to announce the release of a SQL Server AlwaysOn template in the Microsoft Azure Portal Gallery. This offering was announced in Scott Guthrie’s blog post along with several other exciting new features.

This template fully automates the configuration of a highly available SQL Server deployment on Azure Infrastructure Services using AlwaysOn Availability Groups.

AlwaysOn Availability Groups

AlwaysOn Availability Groups, released in SQL Server 2012 and enhanced in SQL Server 2014, guarantee high availability for mission-critical workloads. Last year we started supporting Availability Groups on Azure Infrastructure Services. The main components of such a configuration are two SQL Server replicas (a primary and a secondary), and a listener (DNS name). The replicas are configured for automatic failover, and each replica is contained on a distinct Virtual Machine. The listener is a DNS name that client applications can use in their connection string to connect to the current primary replica. The image below shows a depiction of this setup.

 Other components required are a file share witness to guarantee quorum in the configuration to avoid “split brain” scenarios, and a domain controller to join all VMs to the same domain. Similar to the SQL replicas, there is a primary and secondary domain controller to prevent a single point of failure for the domain. The SQL replicas are deployed to an availability set to ensure they are in different Azure failure and upgrade domains. Likewise, the domain controller replicas are in their own availability set. The configuration is depicted in the image below.

 

SQL Server AlwaysOn Template

Setting up the Availability Group configuration requires a long set of steps and a decent time commitment. In order to dramatically simplify this, we have released a SQL Server AlwaysOn template in the Azure Gallery. This template fully automates the configuration of a highly available SQL Server deployment on Azure Infrastructure Services using an Availability Group. Currently, this feature only supports SQL Server 2014 Enterprise images.

The SQL Server AlwaysOn Template, depicted below, is found in the Gallery under “Virtual Machines” and “Recommended”.

 

After selecting it, it will show a description of the configuration that will be created, and the option to specify some arguments. This is depicted in the picture below.

The only arguments required are a Resource Group (an identifier of the deployment) and administrator credentials. From that point on, all settings are optional and will be auto-generated based on these 3 inputs. The domain Sysadmin account, the local SQL Server accounts, and the SQL Server service account password will be auto-generated based on the credentials entered. The names for all resources being created will be based off of what was entered for Resource Group name. The SQL Server service account name and the domain name will be auto-generated but will not be based on the Resource Group name or credentials. If you wish to customize any of these arguments, simply go to the other configurations and change the values entered for any setting. One argument that you may want to change is the Listener name, which your applications will use to connect to SQL Server. By default, entirely new resources will be provisioned for you. You have the option to select an existing domain for the deployment. In future updates, there will be more options to add existing resources to your configuration.

After the template has executed, 5 Virtual Machines will be created under the resource group: 2 Standard A5 VMs for the SQL Server replicas, 2 Standard A1 VMs for the Domain Controller replicas, and 1 Basic A0 VMs for the file share witness. This is depicted below:

You can RDP to one of the SQL Server VMs to see the Availability Group configuration as depicted below:

Try out the SQL Server AlwaysOn Template today by going to the Azure portal: http://portal.azure.com/


SQL Server Team Blog

{ Comments on this entry are closed }

AnandTech founder leaves site, joins Apple

September 1, 2014

Anand Lal Shimpi, the editor and publisher of the well-regarded AnandTech site, is going to work at Apple. An Apple rep confirmed that the company was hiring Shimpi, but wouldn’t provide any other details. Last night, via a post on the site he founded in 1997, Shimpi said he was “officially retiring from the tech […]

Read the full article →

Amazon Vs. Hachette: Fewer Middlemen Equals A Better World

August 31, 2014

 By now everyone is well aware of the ongoing battle between Amazon and publisher Hachette. The thing is, we all know how this story ends, we just don’t know when it will be over. This one does not have a David vs. Goliath ending. Goliath is going to win — and that is a good […]

Read the full article →

This time it’s personal

August 31, 2014

Anyone who’s argued over the TV remote knows that sharing a living room doesn’t mean you want to share everything else. The same is true on the web. So in the latest Chrome beta, we’re exploring a new way for you to share your computer without sharing your business. Get started by clicking on “You” […]

Read the full article →

Released: Update Rollup 14 for Exchange Server 2007 Service Pack 3

August 30, 2014

The Exchange team is announcing today the availability of Update Rollup 14 for Exchange Server 2007 Service Pack 3. This latest rollup supports recent DST updates. The rollup contains all previously released security bulletins and fixes and updates for Exchange Server 2007 Service Pack 3 as well. This is not a security release, but customers […]

Read the full article →

HOTFIX: A backup to Azure Backup fails if the data source is larger than 850 GB

August 30, 2014

When you use Azure Backup to back up your data, the backup fails if the data source is larger than 850 gigabytes (GB). A typical data source in such a case is a volume, a Hyper-V virtual machine or a Microsoft SQL Server database. For additional details and a link to a downloadable hotfix that […]

Read the full article →

Released: Update Rollup 7 for Exchange Server 2010 Service Pack 3

August 29, 2014

The Exchange team is announcing today the availability of Update Rollup 7 for Exchange Server 2010 Service Pack 3. Update Rollup 7 is the latest rollup of customer fixes available for Exchange Server 2010 Service Pack 3. The release contains fixes for customer reported issues and previously released security bulletins. Update Rollup 7 is not […]

Read the full article →

PASS Summit 2014 – Don’t miss the largest conference for SQL Server Professionals

August 29, 2014

Do you have the “Data Gene”?  Preparations for PASS Summit 2014 in Seattle, Washington are well underway.  We are very excited to have this year’s event back in Seattle and look forward to bringing you some great sessions and activities throughout the event.     Tune in to this week’s TechNet Radio special to listen to […]

Read the full article →

‘How we’re addressing misleading apps in Windows Store’

August 29, 2014

Microsoft has explained that they have removed more than 1500 apps from the store. Every app store finds its own balance between app quality and choice, which in turn opens the door to people trying to game the system with misleading titles or descriptions. Our approach has long been to create and enforce strong but […]

Read the full article →

Released: Cumulative Update 6 for Exchange Server 2013

August 28, 2014

The Exchange team is announcing today the availability of our most recent quarterly servicing update to Exchange Server 2013. Exchange Server 2013 Cumulative Update 6 and updated UM Language Packs are now available on the Microsoft Download Center. CU6 represents the continuation of our Exchange 2013 servicing and builds upon Exchange 2013 CU5. The release […]

Read the full article →