SQL Server ® Always On Series: - PowerPoint Presentation

Slide1

SQL

Server

®

Always On Series:

Part 2: SQL

Server

®

Failover Clustering Deep Dive

Max Verun, Farzan Ratistari, Ahmed Bisht –

Microsoft

®

CorporationSlide2

Deployments and Best Practices

Ensuring IT services

and operational

continuity in the

enterpriseProtect missioncritical SQL Server®databases using Always On Technologies

Always On Series TalksSlide3

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 TimeData loss during unplanned downtimeMinimal planned downtimeDisaster 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 Slide4

SQL

Server®

failover clusters for mission-critical scenariosRolling failover cluster upgrades and patchesDemo: Rolling patchDemo: Add Node to SQL Server

® 2008 RTM+SP1 cluster using slipstreamVirtualization supportValuable resources

Windows Server® 2008/R2 failover cluster improvementsDemo: Windows Server® 2008/R2 Failover Clusters

AgendaSlide5

Database Downtime Driver

s

Failover Clusters:

Instance-level HA

Automatic failure detectionAutomatic failoverFailover Clusters (SQL Server® 2008):Rolling in-place upgrade with minimal downtimeRolling patch with minimal downtime

Add node (at RTM+SP+CU level, all at once), with no downtime

IT-Pro and DBA ChallengesSlide6

Best practice – Installation of prerequisites

Passive

Active

Step #1:

Install Prerequisites:

1-

Microsoft

.Net

Framework

®

3.5 SP1

2-

Microsoft Windows Installer

®

4.5

3-

On Windows Server

®

2003,

QFE (KB937444)

4-

SQL Server

®

2008

Setup Support filesREBOOT….

Step #2:Install Prerequisites:1- Microsoft .Net Framework® 3.5 SP12- Microsoft Windows Installer® 4.53- On Windows Server® 2003, QFE (KB937444)4- SQL Server® 2008 Setup Support filesREBOOT …..

SQL Server

® Instance Manual Failover

Rolling

Failover Cluster UpgradeSlide7

Active

Passive

Step #4:

Upgrade to SQL

Server

®

2008 on Active Node

Step #3:

Upgrade to SQL

Server

®

2008 on Passive Node

Step 5:

SQL Server

®

Instance Automatic Failover

No client connection for 1-2 minutes while db is being upgraded to 2008 on the left node

SQL Server®

2008

SQL Server®

2008

Active

Removed from Cluster Group Possible

Owners

Rolling

Failover Cluster Upgrade

After Pre-requisites

Upgrades from:

SQL

Server

®

2000 SP4

SQL

Server

®

2005 SP2Slide8

Rolling patch and Service Pack with minimal downtime for SQL

Server®

2008Manual process: http://support.microsoft.com/kb/958734

Rolling Failover Cluster PatchSlide9

SQL

Server®

2008 Failover ClusterRolling PatchdemoSlide10

Slipstream SQL

Server® 2008 Failover Cluster Setup

You can add a node at RTM+SP+CU level all at once, in one stepNo downtime while extending the HA capacity

On Windows Server® 2008 R2, SQL Server

® 2008 RTM+SP1 slipstream is requiredHow to Increase SQL Server HA CapacitySlide11

SQL

Server®

2008 Failover ClusterAdd Node at RTM+SP1 Using Slipstream Setup

demoSlide12

Aligned with virtualization technologies

Guest failover clustering support enabledSQL Server

® 2008SQL Server® 2005Hyper-V and third-party solutions

Virtualization SupportSlide13

Whitepapers:

SQL Server

® 2008 Failover ClusteringRunning SQL Server®

2008 in a Hyper-V Environment - Best Practices and Performance Recommendations

Valuable ResourcesSlide14

What is New in Windows

Server®

2008 and 2008 R2 for Failover Clustering?Slide15

Integrated Test tool with Validate

Streamlined Setup

Brand new GUI snap-in

Fully featured WMI provider

MOM Management Pack

Faster File Server Failover

Server Core support

Shell integration

Scoping of SMB Shares

Task based wizard user experience

Logo requirement for Server Apps

Improved Security

LocalSystem account for manageability

Solutions to Support Top 10

Self healing Service and Storage

New VSS Writer

SQM Support

Converted all eventing to ETW

Improved Actionable Eventing

Online Resource Dependency Modification

Rewritten Storage Stack

Persistent Reservation Support

Large GPT Volume Support

16-Node Support

New Quorum Model

Auditing of Cluster Access

Internode Encryption

IPv6 Support

New Support Model

DHCP Support

Dissimilar Subnet Support

Configurable Heartbeating

Windows

Server

®

2008 Failover ClustersSlide16

PowerShell

Storage access redirection

More logging channels

Storage network fault tolerance

Auto start

Integration with VMM

Enhanced validation

Driver isolation in print clusters

Better storage management

Network prioritization

Performance counters

Solutions to Support Top 10

Save events to

evtx

file

DFSR support

Remote Desktop Connection Broker support

GUI scalability enhancements

Live migration

Tighter Hyper-V integration

Persistent mode

Enhanced validation with BPA

New clustered workloads

Complete migration support

Read-only cluster access

Management packs

Cluster Shared Volumes (CSV)

Windows

Server

®

2008 R2 Failover ClustersSlide17

Windows

Server

® 2008 andWindows Server

® 2008 R2

Failover ClustersdemoSlide18

question & answerSlide19

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 areaDrop off your completed Form:Near the exit of each presentation roomAt the PASS Booth near registration areaSponsored by DellSlide20

Thank you

for attending this session and the

2009 PASS Summit in SeattleSlide21

Visit the

Microsoft Technical Learning Center

Located in the Expo Hall

Microsoft Ask the Experts Lounge

Microsoft Chalk Talk Theater Presentations