Building Highly Available Systems with SQL Server 2005.pdf

(1488 KB) Pobierz
Clustering
Highly Available
Systems with
SQL Server 2005
Raj Gill
Scalability Experts
Building
30294469.010.png 30294469.011.png
Agenda
What is High Availability
HA Technology Enhancements in
SQL Server 2005
Right tool for the right job
30294469.012.png
What is High Availability
Uninterrupted usability
A running server is not necessarily available
Is a factor of technology, people and processes
Often measured as a percentage in “uptime” over 1
year
Eg. 99.999% uptime = 5.25 minutes downtime a year
Includes both planned and unplanned downtime
You really should care
Typical cost of downtime: $20K-$80K /hour
High watermark: $6.5million /hour
43% of companies experiencing disaster never re-open
30294469.013.png 30294469.001.png 30294469.002.png 30294469.003.png 30294469.004.png 30294469.005.png
Clustering
High Availability Technology
Enhancements in SQL Server 2005
Failover
30294469.006.png
Changes To Clustering
Supports 8-node clustering
Windows Server 2003 Enterprise Edition
Windows Server 2003 Datacenter Edition
Install package chaining allows for one-step clustering
Analysis Services can be clustered in multiple instances
Full Text Search can be clustered in multiple instances
Allows for optional components selection
30294469.007.png 30294469.008.png 30294469.009.png
Zgłoś jeśli naruszono regulamin