Since the first release of the SQLskills Availability Group Demonstrator, I’ve had an number of requests to add the ability to enable MultiSubnetFailover in the connection string, and to specify a Timeout value. I made these changes months ago but never got around to actually releasing the newer build on my blog. However, after releasing the two add-ins yesterday, I took a few minutes and ran through testing the demonstrator application against my local Availability Group and then uploaded the latest build for download.
Related Posts
- New Article: VMware CPU Hot Plug vNUMA Effects on SQL Server
- Creating a new Login on Multiple Servers with the same SID using Powershell
- Does tempdb Get Recreated From model at Startup?
- Tuning ‘cost threshold for parallelism’ from the Plan Cache
- An XEvent a Day (29 of 31) – The Future – Looking at Database Startup in Denali
4 thoughts on “Updated Availability Group Demonstrator”
Nice work Jon. I use it to generate connection string for various failover scenario. This saves lots of time in application failover test.
Quick question-could you please let me know how we can connect with SQL login to Availabilty group?
Hey Vijay,
In the app, the default is to use a SQL Login for the connection string.
Thnaks for reply Jonathan.Do you have any document for availibity group for hardware and software requirement and step by step implemenation? Actually our SAS datacenter does not provide clustring support and want implement AG as high avaibillity solution.