SQL Server Always On Series Part 2 SQL

SQL Server® Always On Series: Part 2: SQL Server® Failover Clustering Deep Dive Max Verun, Farzan Ratistari, Ahmed Bisht – Microsoft® Corporation

Always On Series Talks Ensuring IT services Part 1: Building a High and operational Availability Strategy for your Enterprise continuity in the • Tue enterprise Part 2: SQL Server Failover Clustering Deep Dive Protect mission critical SQL Server® using Partdatabases 3: SQLCAT Customer Deployments, Best Practices & Always On Panel Discussion Technologies Maintenance Analysis Testing Solution Design • Now • Wed 3: 00 PM Implementation Deployments and Best Practices

Defining HA and DR High Availability (HA) • High availability is a system design protocol and associated implementation that ensures a certain absolute degree of operational continuity during a given measurement period. • Availability defined in terms of service level agreements (SLA) • Recovery Time • Data loss during unplanned downtime • Minimal planned downtime Disaster Recovery (DR) • Processes and procedures designed to restore business operations due to a natural or human-induced disaster • Typically involves providing redundancy spanning multiple sites or across geographic regions

Agenda • SQL Server® failover clusters for mission-critical scenarios • Rolling failover cluster upgrades and patches • Demo: Rolling patch • Demo: Add Node to SQL Server® 2008 RTM+SP 1 cluster using slipstream • Virtualization support • Valuable resources • Windows Server® 2008/R 2 failover cluster improvements • Demo: Windows Server® 2008/R 2 Failover Clusters

Database Downtime Drivers IT-Pro and DBA Challenges Database Downtime Unplanned Downtime Failure Protection User Errors Failover Clusters: • Instance-level HA • Automatic failure detection • Automatic failover Planned Downtime Online Administration Predictable Resourcing Failover Clusters (SQL Server® 2008): • Rolling in-place upgrade with minimal downtime • Rolling patch with minimal downtime • Add node (at RTM+SP+CU level, all at once), with no downtime

Rolling Failover Cluster Upgrade Best practice – Installation of prerequisites Step #2: Install Prerequisites: 1 - Microsoft. Net Framework® 3. 5 SP 1 2 - Microsoft Windows Installer® 4. 5 3 - On Windows Server® 2003, QFE (KB 937444) 4 - SQL Server® 2008 Setup Support files REBOOT …. . Active Step #1: Install Prerequisites: 1 - Microsoft. Net Framework® 3. 5 SP 1 2 - Microsoft Windows Installer® 4. 5 3 - On Windows Server® 2003, QFE (KB 937444) 4 - SQL Server® 2008 Setup Support files REBOOT…. SQL Server® Instance Manual Failover Passive

Rolling Failover Cluster Upgrade After Pre-requisites Step #4: Upgrade to SQL Server® 2008 on Active Node Step #3: Upgrade to SQL Server® 2008 on Passive Node SQL Server® 2008 Removed from Cluster Group Possible Owners Passive Active Upgrades from: SQL Server® 2000 SP 4 SQL Server® 2005 SP 2 No client connection for 1 -2 minutes while db is being upgraded to 2008 on the left node SQL Server® 2008 Active Step 5: SQL Server® Instance Automatic Failover

Rolling Failover Cluster Patch • Rolling patch and Service Pack with minimal downtime for SQL Server® 2008 • Manual process: http: //support. microsoft. com/kb/958734

demo SQL Server® 2008 Failover Cluster Rolling Patch

How to Increase SQL Server HA Capacity • Slipstream SQL Server® 2008 Failover Cluster Setup • You can add a node at RTM+SP+CU level all at once, in one step • No downtime while extending the HA capacity • On Windows Server® 2008 R 2, SQL Server® 2008 RTM+SP 1 slipstream is required

demo SQL Server® 2008 Failover Cluster Add Node at RTM+SP 1 Using Slipstream Setup

Virtualization Support • Aligned with virtualization technologies • Guest failover clustering support enabled • SQL Server® 2008 • SQL Server® 2005 • Hyper-V and third-party solutions

Valuable Resources • Whitepapers: • SQL Server® 2008 Failover Clustering • Running SQL Server® 2008 in a Hyper-V Environment - Best Practices and Performance Recommendations

What is New in Windows Server® 2008 and 2008 R 2 for Failover Clustering?

Windows Server® 2008 Failover Clusters Online Resource Dependency Modification Solutions to Support Top 10 Rewritten Storage Stack Integrated Test Fully featured Local. System Auditing of tool with Dissimilar Cluster Access WMI provider account for Validate Subnet Support manageability Logo Task based requirement for New Quorum Improved wizard user Server Apps Model Security DHCP Support experience New Support Brand new GUI Streamlined MOM Configurable Model snap-in Setup Heartbeating Management Pack IPv 6 Support New VSS Persistent Large GPT Writer Improved Reservation Scoping of SMB Volume Support Actionable Support Shares Internode Eventing Encryption Shell integration Faster File Server Core Server Failover support Self healing Converted all SQM Support Service and 16 -Node eventing to Storage Support ETW

Windows Server® 2008 R 2 Failover Clusters Cluster Shared Volumes (CSV) Solutions to Support Top 10 Live migration Remote Desktop Driver isolation Power. Shell More logging Connection in print clusters channels Broker support Network Performance Enhanced prioritization counters validation with Management Read-only BPA packs Storage cluster access Storage access network fault redirection Auto start tolerance Tighter Hyper-V Save events to integration Complete evtx file Persistent Better storage migration mode management support New clustered GUI scalability workloads Integration with enhancements Enhanced VMM DFSR support validation

demo Windows Server® 2008 and Windows Server® 2008 R 2 Failover Clusters

question & answer

Complete the Evaluation Form & Win! • You could win a Dell Mini Netbook – every day – just for handing in your completed form! Each session form is another chance to win! Pick up your Evaluation Form: • Within each presentation room • At the PASS Booth near registration area Drop off your completed Form: • Near the exit of each presentation room • At the PASS Booth near registration area Sponsored by Dell

Thank you for attending this session and the 2009 PASS Summit in Seattle

Visit the Microsoft Technical Learning Center Located in the Expo Hall Microsoft Ask the Experts Lounge Microsoft Chalk Theater Presentations