Microsoft SQL Server 2008 R2 810-08230 User Manual
Product codes
810-08230
63
C H A P T E R 4
High Availability and
Virtualization Enhancements
M
icrosoft SQL Server 2008 R2 delivers several enhancements in the areas of high
availability and virtualization. Many of the enhancements are affiliated with the
availability and virtualization. Many of the enhancements are affiliated with the
Windows Server 2008 R2 operating system and the Hyper-V platform . Windows Server
2008 R2 builds on the successes and foundation of Windows Server 2008 by expand-
ing on the existing high availability technologies, while adding new features that allow
for maximum availability and reliability for SQL Server 2008 R2 implementations . This
chapter discusses the enhancements to high availability that significantly contribute to
the capabilities of SQL Server 2008 R2 in both physical and virtual environments .
2008 R2 builds on the successes and foundation of Windows Server 2008 by expand-
ing on the existing high availability technologies, while adding new features that allow
for maximum availability and reliability for SQL Server 2008 R2 implementations . This
chapter discusses the enhancements to high availability that significantly contribute to
the capabilities of SQL Server 2008 R2 in both physical and virtual environments .
Enhancements to High Availability with
Windows Server 2008 R2
In the following list are a few of the improvements that will appeal to SQL Server and
Windows Server professionals looking to gain maximum high availability within their
database infrastructures .
Windows Server professionals looking to gain maximum high availability within their
database infrastructures .
■
Hot add CPU and memory
When using SQL Server 2008 R2 in conjunction
with Windows Server 2008 R2, database administrators can upgrade hardware
online by dynamically adding processors and memory to a system that supports
dynamic hardware partitioning . This is a very convenient feature for organizations
that cannot endure downtime for SQL Server systems running in mission-critical
environments .
online by dynamically adding processors and memory to a system that supports
dynamic hardware partitioning . This is a very convenient feature for organizations
that cannot endure downtime for SQL Server systems running in mission-critical
environments .
■
Failover clustering
Greater high availability is achievable for SQL Server R2 with
failover clustering on Windows Server 2008 R2 . Windows Server 2008 R2 enhances
the failover cluster installation experience by increasing the number of validation
tests within the Cluster Validation Wizard . Moreover, Windows Server 2008 R2
introduces a Best Practices Analyzer tool to help database administrators reduce best
practice violations . Similar to its predecessor, Windows Server 2008 R2 continues to
supports up to 16 nodes within a failover cluster and organizations can also protect
their applications from site failures with SQL Server multi-site failover cluster support
by using stretched VLANs built on Windows Server support for multi-site clusters .
the failover cluster installation experience by increasing the number of validation
tests within the Cluster Validation Wizard . Moreover, Windows Server 2008 R2
introduces a Best Practices Analyzer tool to help database administrators reduce best
practice violations . Similar to its predecessor, Windows Server 2008 R2 continues to
supports up to 16 nodes within a failover cluster and organizations can also protect
their applications from site failures with SQL Server multi-site failover cluster support
by using stretched VLANs built on Windows Server support for multi-site clusters .