Microsoft® SQL ServerTM 2000 High Availability
Get the definitive reference to maximizing the availability of your critical, SQL Server 2000-based business systems. Developed by Microsoft field consultants who create and support high availability solutions every day, this practical guide explains how to plan, design, implement, and support high...
| Autor principal: | |
|---|---|
| Otros Autores: | , , |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol :
Microsoft Press
2009.
|
| Edición: | 1st edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627173406719 |
Tabla de Contenidos:
- Microsoft® SQL ServerTM 2000 High Availability; Preface; Acknowledgments; Cathan Cook; Frank McBath; Kimberly L. Tripp; I. The High Availability Primer; Disaster Recovery; Agreeing on a Solution; Guiding Principles for High Availability; Making Trade-Offs; Identifying Risks; Next Steps; Availability Calculations and Nines; What Is a Nine?; What Level of Nines Is Needed?; Negotiating Availability; Types of Unavailability; Where Does Availability Start?; The Cost of Availability; Barriers to Availability; Summary; 2. The Basics of Achieving High Availability; Security
- Cabling, Power, Communications Systems, and NetworksThird-Party Hosting; Support Agreements; The ""Under the Desk"" Syndrome; Staffing; Service Level Agreements; Manage Change or Be Managed by It; Development, Testing, and Staging Environments; Managing Change and Availability in Development; Version Control; Testing Applications for High Availability; Managing Change in Production; Preparing for Change; Contingency Plans; Implementation Team; Determining an Implementation Window; Planning the Implementation, Twice; Testing the Implementation; Release Readiness Review
- Completing a Change Request FormImplementing Change; Step 2: Back Up, Back Up, Back Up; Step 3: The Rollout; Step 4: When It Is All Over; System and Process Standardization; Documentation; Summary; 3. Making a High Availability Technology Choice; Cluster Concepts; Network Load Balancing Clusters; Geographically Dispersed Clusters; SQL Server 2000; How SQL Server Failover Clustering Works; Clients and SQL Server 2000 Failover Clustering; Failover Clustering and Wasted Resources; Log Shipping; Clients and Log Shipping; Replication; Clients and Replication; Backup and Restore
- Decisions, Decisions ...Step 2: Comparing Technologies; Step 3: Selecting Technology; A Comparison of the SQL Server Technologies; Choosing Between Failover Clustering and Log Shipping or Replication; Using the SQL Server Availability Technology Comparison Table; What Should You Use?; Summary; II. Technology Building Blocks; Capacity Planning; Application Database Usage; Indexes; Deletes, Inserts, Selects, and Updates; Understanding Physical Disk Performance; Using SQL Server to Assist with Disk Capacity Planning; Types of Disk Subsystems; Network-Attached Storage
- Using Network-Attached Storage as a Data Store with SQL ServerStorage Area Networks; What Disk Technology to Use; Server Clusters, Failover Clustering, and Disks; Pre-Windows Disk Configuration; Step 2-Individual Drive Throughput; Step 3-Calculating Number of Spindles; Understanding Disk Drives; Understanding Your Hardware; Understanding How SQL Server Interacts with Disks; Understanding Disk Cache; A RAID Primer; Mirroring; Striped Mirrors; Mirrored Stripes; Striping with Parity; Hardware RAID versus Software RAID; Remote Mirroring; Storage Composition
- Types of Disks and File Systems in Windows
