Availability Group Demonstrator

Download541 downloads
This is the application we use to demonstrate the features of Availability Groups in SQL Server 2012 at conferences and during our Immersion Events. The application provides a multi-document interface that allows multiple connections with different configurations for read-only and/or read-write workloads to demonstrate the connection failover, read-only routing, and multi-subnet failover features of Availability Groups in SQL Server 2012.

Availability Group Demonstrator 300x205 Availability Group Demonstrator

Requirements

The application requires .NET 4.0 and the SQL Server 2012 Native Client be installed to make use of the new ApplicationIntent connection string option. You also need to create the following table in whatever database you are using for the demonstration:

USE [DBNAME]
GO
CREATE TABLE InsertCount (RowID int identity primary key)
GO
INSERT INTO InsertCount DEFAULT VALUES;
GO