Building NextGen Scalable & Highly Available Architectures with Microsoft SQL Server 2008 R2

Explore advanced techniques for building highly scalable and available architectures using Microsoft SQL Server 2008 R2 in this comprehensive conference talk from PASS Data Community Summit. Dive deep into the latest features and their implementation requirements, examining real-world customer reference architectures for both scale-up and scale-out scenarios. Learn about crucial scalability, high availability, and disaster recovery features, including database mirroring, snapshot databases, clustering, resource governance, and Peer-to-Peer replication. Discover how SQL Server 2008 R2 enhancements can drive business improvements in enterprise database environments, with insights from a real-world implementation and lessons learned. Gain valuable knowledge on addressing data management challenges, understanding different database workloads, and leveraging key technologies such as server virtualization support, live migration, and shared services architecture. Master best practices for consolidation, virtualization, and implementing a robust data access framework to create next-generation database solutions.

Introduction
Agenda
Data Management Challenges
Reasons for Data Management Challenges
Database Workloads
ReadWrite Compromise
WeApps
Paradigm Shift
Key Technologies Features
Guest OS Support
Live Migration
Server Virtualization Support
Shared Services Architecture
Non VM Shared Services Architecture
Resource Governor
Resource Pool
Classifier Function
Best Practices
Consolidation
Virtualization
PeertoPeer
Data Access Framework
Database snapshots
Database snapshot example
How Snapshots work
Reference Architecture