E-raamat: SQL Server AlwaysOn Revealed

  • Formaat: 150 pages, 100 black & white illustrations, biography
  • Ilmumisaeg: 11-Dec-2015
  • Kirjastus: APress
  • ISBN-13: 9781484217634
Teised raamatud teemal:
  • Formaat - PDF+DRM
  • Hind: 19,94 EUR*
  • Lisa soovinimekirja
  • Lisa ostukorvi
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • See e-raamat on mõeldud ainult isiklikuks kasutamiseks.
  • Raamatukogudele
    • EBL
  • Formaat: 150 pages, 100 black & white illustrations, biography
  • Ilmumisaeg: 11-Dec-2015
  • Kirjastus: APress
  • ISBN-13: 9781484217634
Teised raamatud teemal:

DRM piirangud

  • Kopeerimine (copy/paste):

    ei ole lubatud

  • Printimine:

    ei ole lubatud

  • Kasutamine:

    E-raamatu lugemiseks on vaja luua Adobe ID ning laadida arvutisse Adobe Digital Editions. Lähemalt siit. E-raamatut saab lugeda ning alla laadida kuni 6'de seadmesse.
    E-raamatut ei saa lugeda Amazon Kindle's. Ülejäänud meie e-poes pakutavad e-lugerid võimaldavad lugeda Adobe ID-ga kaitstud e-raamatuid.

Get a fast start to using AlwaysOn, the SQL Server solution to high-availability and disaster recovery. Read this short, 150-page book that is adapted from Peter Carter’sPro SQL Server Administration to gain a solid and accurate understanding of how to implement systems requiring consistent and continuous uptime.

Begin with an introduction to high-availability and disaster recovery concepts such as Recovery Point Objectives (RPOs), Recovery Time Objectives (RTO), availability levels, and the cost of downtime. Then move into detailed coverage of implementing and configuring the AlwaysOn feature set in order to meet the business objectives set by your organization.

SQL Server AlwaysOn Revealed offers real-world advice on how to build and configure the most appropriate topology to meet the high-availability and disaster recovery requirements you are faced with. Content includes strong coverage on implementing clusters, on building AlwaysOn failover clustered instances, and on configuring AlwaysOn Availability Groups. This is a practical and hand-on book to get you started quickly in using one of the most talked-about SQL Server feature sets.

  • Teaches you to build HA and DR solutions using the AlwaysOn feature set
  • Provides real-world advice on configuration and performance considerations
  • Demonstrates administrative techniques for the AlwaysOn feature set

What You Will Learn

  • Understand high availability and disaster recovery concepts and terminology.
  • Understand the technologies available, to implement HA and DR.
  • Build and configure a Windows Cluster.
  • Build and configure an AlwaysOn failover clustered instance.
  • Implement AlwaysOn Availability Groups and appropriately configure them.
  • Administer AlwaysOn technologies post implementation.

Who This Book Is For

SQL Server AlwaysOn Revealed is for database administrators interested in growing their knowledge and skills in Microsoft SQL Server’s high-availability and disaster recovery feature set.

 

About the Author xi
About the Technical Reviewers xiii
Chapter 1 High Availability and Disaster Recovery Concepts
1(6)
Level of Availability
1(2)
Service-Level Agreements and Service-Level Objectives
3(1)
Proactive Maintenance
3(1)
Recovery Point Objective and Recovery Time Objective
3(1)
Cost of Downtime
4(1)
Classification of Standby Servers
5(1)
Summary
6(1)
Chapter 2 Understanding High Availability and Disaster Recovery Technologies
7(20)
AlwaysOn Failover Clustering
7(6)
Active/Active Configuration
8(1)
Three-Plus Node Configurations
9(2)
Quorum
11(2)
Database Mirroring
13(3)
AlwaysOn Availability Groups
16(5)
Automatic Page Repair
20(1)
Log Shipping
21(2)
Recovery Modes
21(1)
Remote Monitor Server
22(1)
Combining Technologies
23(3)
Summary
26(1)
Chapter 3 Implementing a Cluster
27(30)
Building the Cluster
27(18)
Installing the Failover Cluster Feature
27(6)
Creating the Cluster
33(12)
Configuring the Cluster
45(11)
Changing the Quorum
45(4)
Configuring MSDTC
49(5)
Configuring a Role
54(2)
Summary
56(1)
Chapter 4 Implementing an AlwaysOn Failover Clustered Instance
57(14)
Building the Instance
57(12)
Preparation Steps
57(1)
Cluster-Specific Steps
57(6)
Installing the Instance with PowerShell
63(1)
Adding a Node
64(5)
Summary
69(2)
Chapter 5 Implementing AlwaysOn Availability Groups
71(58)
Implementing High Availability with AlwaysOn Availability Groups
71(32)
Configuring SQL Server
76(2)
Creating the Availability Group
78(20)
Performance Considerations for Synchronous Commit Mode
98(5)
Implementing Disaster Recovery with Availability Group
103(24)
Configuring the Cluster
103(10)
Configuring the Availability Group
113(14)
Adding AlwaysOn Readable Secondary Replicas
127(1)
Summary
128(1)
Chapter 6 Administering AlwaysOn
129(20)
Managing a Cluster
129(6)
Moving the Instance between Nodes
129(4)
Removing a Node from the Cluster
133(2)
Managing AlwaysOn Availability Groups
135(12)
Failover
135(5)
Synchronizing Uncontained Objects
140(1)
Monitoring
140(3)
Adding Multiple Listeners
143(3)
Other Administrative Considerations
146(1)
Summary
147(2)
Index 149
Peter Carter is a SQL Server expert with over a decade of experience in developing, administering, and architecting SQL Server platforms and data-tier applications. Peter was awarded an MCC by Microsoft in 2011, and it sits alongside his array of MCTS, MCITP, MCSA and MCSE certifications in SQL Server from version 2005 onward. His passion for SQL Server shows through in everything he does, and his goal is that his passion for the technology will inspire others.