DBI302. SQL Server “Denali” AlwaysOn Part 1: Introducing the Next Generation High Availability Solution . Santosh Balasubramanian Program Manager Microsoft Corporation. SQL Server High Availability Retrospective. SQL Server High Availability Today Enterprise customers are being successful
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 “Denali” AlwaysOnPart 1: Introducing the Next Generation High Availability Solution
AlwaysOn Availability Groups
for database protection
AlwaysOn Failover Cluster Instances
for instance level protection
New AlwaysOn solutions
Reuse existing investment
SAN versus DAS environments
AlwaysOn Availability Groups is a new feature that enhances and combines database mirroring and log shipping capabilities
Direct attached storage local, regional and geo target
Shared Storage, regional and geo secondaries
Asynchcronous Data Movement
Mission Critical RequirementsZero data loss is critical for the businessFast application recovery during planned and unplanned downtimeRedundancy across 3 datacentersApplication databases and dependencies failover together
Deploying using AlwaysOn Availability Groups
Application retry during failover
Connect to new primary once
failover is complete
and the listener is online
-server HR_Listener;-catalog HRDB
Windows Server Failover Cluster
Active Log Synchronization
Active Log Synchronization
Availability Group uses Windows Server Failover Cluster (WSFC) for
WSFC Common Microsoft Availability Platform
AlwaysOnActive Secondary enables efficient utilization of high availability hardware resources thereby improving overall IT efficiency
Active Secondary Demo
Flexible Failover Policy provides administrators control over the
conditions when an automatic failover should be initiated.
SQL Server 2008 R2
SQL Server Denali
Configurable options eliminate false failover
Improved logging for better diagnostics
Denali is a huge leap forward for customer’s DB HA needs!
Track PMs will supply the content for this slide, which will be inserted during the final scrub.
Try the new SQL Server Mission Critical BareMetal Hand’s on-Labs
Complete an evaluation on CommNet and enter to win!
© 2011 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.