I pondered a lot of time, what should I blog about?
Eventually I came up with this idea of aggregating all the links that I have collected/read about AlwaysOn Availability Groups.
Why Availability Groups?- It is the hottest topic in SQL Server 2012.
Since it is a new topic, Many database administrators and system administrators will have a lot of questions and hence will search the web for information. So I thought, why not aggregate the information and put it in one place.
I will try to keep the list as updated as possible.
So Here is the List.
Prerequisites, Restrictions, and Recommendations for AlwaysOn Availability Groups (SQL Server)
General Info about Availability groups
A series of Blog posts about AlwaysOn availability groups from BrentOzar PLF
Configuring AlwaysOn with Powershell
Availability Group Listener
Video about AlwaysOn Availability Group Listener.
Creating Multiple listeners for the same availability group
Flexible failover policy
This Blog post by Remus Rusanu about Availability Groups is simple and easy to understand.
The AlwaysOn Blog has excellent posts about Readable Secondaries. All the Internals that you want to learn about Active Secondaries
can be found here.(Temporary Statistics, Snapshot Isolation etc...)
Configuring Secondary Read Only Access
Blog post about Configuring Readable Secondary routing
Wiki Article on Read only Routing
A Very handy script that will generate the ROR URL for you- Written By matt Neerincx
AlwaysOn and Backups
An excellent 3-part series by fellow PFE ,Lisa Gardner on Backups on Active Secondaries.
Availability Groups and Kerberos
A blog post by Robert about Using Availability Groups with Kerberos
Excellent Post by Pareekshit explaining about Asymmetric Storage.
Converting a Logshipping configuration to availability group
Blog post explaining ,how you can convert your existing Logshipping architecture to an Availability Group Architecture.
Troubleshooting and Monitoring
Joe Sack’s blog post about the various wait statistics associated with Availability groups
Another blog post by Joe Sack about Always on Dashboard and the DMV’s behind the dashboard.
Information about the AlwaysOn Extended Event session –written by Jonathan Kehayias
Monitoring with Powershell
Various Blog posts by the Customer Service and Support Team about the internals of AlwaysOn
Allan Hirt has an Excellent post on various questions on Availability Groups
My fellow PFE and friend Krishna has an Excellent one line answers for various Questions regarding AG
Another FAQ blog post about AlwaysOn
AlwaysOn Architecture Guides and Design Patterns
These Guides explain you about the various design patterns you can implement with AlwaysOn
HA and DR using Failover Cluster Instances.(Multi Subnet)
HA and DR using using Availability Groups.
HA using FCI and DR using Availability Groups
Migrating to SQL Server 2012 Failover Clustering and Availability Groups from Prior Clustering and Mirroring Deployments