Cross posting from SQLCAT blog: http://blogs.msdn.com/b/sqlcat/archive/2014/02/04/alwayson-availability-groups-comparing-on-premises-deployments-and-azure-vm-deployments.aspx
Cross posting from SQLCAT blog: http://blogs.msdn.com/b/sqlcat/archive/2014/02/03/alwayson-availability-groups-listener-named-instances-port-numbers-etc.aspx
Cross posting from SQLCAT blog: http://blogs.msdn.com/b/sqlcat/archive/2014/02/03/alwayson-availability-group-in-windows-azure-vm-client-connectivity-scenarios.aspx
Before the holidays, this article was quietly published: http://msdn.microsoft.com/en-us/library/windowsazure/dn495646.aspx This is a troubleshooting guide for all those going through the joys and pains of configuring the availability group listener in the cloud. There are already guidance on how to configure the listener in Windows Azure or hybrid IT, but no known content that helps you…
In case you’re not already aware, I’ve written additional scripts for Windows Azure deployment of AlwaysOn Availability Groups for you to play with. Windows Azure provides an ever-expanding set of PowerShell cmdlets, which make automated deployments and administration of SQL Server on IaaS a reality. These scripts are there as proofs of concept to you…
Hello, Please check out the script at http://gallery.technet.microsoft.com/scriptcenter/Create-Availability-Group-3fc1ca5e. This script creates a listener for an availability group with replicas both on-premise and in Windows Azure. For information on how to configure the hybrid availability group listener without the script, see http://msdn.microsoft.com/en-us/library/dn425027.aspx. As always, feedback is welcome.
If you haven’t noticed, AlwaysOn Availability Groups in Windows Azure now supports availability group (AG) listeners. Configuring the AG listener in Windows Azure is a multi-step process that includes: Creating a load-balanced endpoint for the Windows Azure VMs that host AG replicas. Ensuring that hotfix KB2854082 is installed on all cluster nodes (including any node…
Failover Cluster Instances as well as Availability Groups have some great features coming up in SQL Server 2014. Take a look at Luis’ post on what you can try out with publicly available CTP1: http://blogs.technet.com/b/dataplatforminsider/archive/2013/06/27/alwayson-in-sql-server-2014-ctp1.aspx
AlwaysOn Availability Groups Troubleshooting and Monitoring Guide provides information on troubleshooting the common AlwaysOn Availability Groups issues and monitoring the availability group health. We will try to keep updating this guide as new troubleshooting scenarios are documented so that you can conveniently find all the information in one place. Please send us feedback on it!
The upgrade/update guide for availability group servers is now live on MSDN. Upgrade and Update of Availability Group Servers with Minimal Downtime and Data Loss It shows how to upgrade/update to any major, minor, service pack, or update release with minimal downtime in multiple deployment scenarios.