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
Agenda
What is High Availability
HA Technology Enhancements in
SQL Server 2005
Right tool for the right job
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
Clustering
High Availability Technology
Enhancements in SQL Server 2005
Failover
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
Plik z chomika:
darekisap
Inne pliki z tego folderu:
Apress - Pro SQL Server 2005 Integration Services (2008).pdf
(15672 KB)
Apress - Pro ASP.NET for SQL Server High Performance Data Access for Web Developers (2007).pdf
(3825 KB)
Apress - Expert SQL Server 2005 Development (2007).pdf
(6481 KB)
Manning - SQL Server 2005 Reporting Services in Action (2006).pdf
(23748 KB)
Wrox - SQL Server 2005 XML (2008).pdf
(12489 KB)
Inne foldery tego chomika:
MS SQL 2000 Server
MS SQL Server 7.0
Zgłoś jeśli
naruszono regulamin