SQL Server 2012 Always On. Lisa Gardner. Premier Field Engineer. Microsoft Corporation. http://blogs.msdn.com/sqlgardner. High Availability Outcome Options. Understanding of High Availability Options in SQL Server 2012 Benefits of AlwaysOn HA design patterns utilizing AlwaysOn. Agenda.
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
SQL Server 2012 Always On
Premier Field Engineer
High Availability OutcomeOptions
5 – Failover or restart on any qualified failure conditions
Query Processing errors
4 – Failover or restart on moderate SQL Server errors
3 – Failover or restart on critical SQL Server errors
2 – Failover or restart on server unresponsive
No response from sp_server_diagnostics
1 – Failover or restart on server down
Service is down
0 – No Automatic Failover or restart
Creating an Availability Group
Leveraging Active Secondaries