1 / 14

Keeping the Lights on with SQL Server 2012 AlwaysOn

Discover how to maintain high availability and disaster recovery in SQL Server 2012 using AlwaysOn. This presentation by Warwick Rudd and Simon Brown from WARDY IT Solutions covers essential topics such as configuring security, managing primary and secondary replicas, and understanding licensing implications. Learn about the technologies involved, historical context, and key management practices to ensure your SQL Server environment remains resilient. Additional resources, including a solutions guide and informative videos, are also provided for deeper insights.

gautier
Download Presentation

Keeping the Lights on with SQL Server 2012 AlwaysOn

An Image/Link below is provided (as is) to download presentation 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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DBI312 Keeping the Lights on with SQL Server 2012 AlwaysOn Warwick Rudd Simon Brown

  2. partner WARDY IT Solutions Warwick Rudd Warwick.Rudd@wardyit.com @Jnrt74 SQL Server Consultant WARDY IT Solutions

  3. Contents

  4. HA/DR In Your Current EnvironmentTechnologies being used

  5. SQL Server 2012 AlwaysOnHistory

  6. SQL Server 2012 AlwaysOnEnvironment

  7. SQL Server 2012 AlwaysOnEnvironment

  8. SQL Server 2012 AlwaysOnManagement

  9. SQL Server 2012 AlwaysOnThings to consider • Configure Security • Primary Replica • Secondary Replica(s) • Licensing • Primary • Secondary

  10. demo AlwaysOn

  11. Additional Materials • AlwaysOn Solutions Guide • http://msdn.microsoft.com/en-us/library/hh781257.aspx • http://www.simple-talk.com/sql/database-administration/sql-server-2012-alwayson/ • YouTube 2 part series video • AlwaysOn Wait Statistics • http://simple-talk.com/sql/database-administration/a-first-look-at-sql-server-2012-availability-group-wait-statistics/

  12. © 2012 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

More Related