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:
adszy1
Inne pliki z tego folderu:
Wrox - Professional SQL Server 2005 CLR Programming (2007).pdf
(8919 KB)
Building Highly Available Systems with SQL Server 2005.pdf
(1488 KB)
Advanced Querying and Query Tuning in SQL Server 2000 and 2005.pdf
(1014 KB)
APress - Pro SQL Server 2005 Database Design and Optimization (2006).pdf
(4893 KB)
McGraw-Hill - MS SQL Server 2005 Reporting Services 2005 (2006).chm
(42441 KB)
Inne foldery tego chomika:
MS SQL 2000 Server
MS SQL Server 7.0
Zgłoś jeśli
naruszono regulamin