SQL Server AlwaysOn Revealed:
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Berkeley, CA
Apress
2016
|
| Ausgabe: | Second edition |
| Schlagworte: | |
| Online-Zugang: | FHM01 FHN01 FHO01 FHR01 FKE01 FWS01 FWS02 UBW01 Volltext Inhaltsverzeichnis |
| Beschreibung: | 1 Online-Ressource (XV, 212 Seiten) 112 Illustrationen (farbig) |
| ISBN: | 9781484223970 |
| DOI: | 10.1007/978-1-4842-2397-0 |
Internformat
MARC
| LEADER | 00000nmm a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV043991049 | ||
| 003 | DE-604 | ||
| 005 | 20170119 | ||
| 007 | cr|uuu---uuuuu | ||
| 008 | 170110s2016 |||| o||u| ||||||eng d | ||
| 020 | |a 9781484223970 |c Online |9 978-1-4842-2397-0 | ||
| 024 | 7 | |a 10.1007/978-1-4842-2397-0 |2 doi | |
| 035 | |a (ZDB-2-CWD)978-1-4842-2397-0 | ||
| 035 | |a (OCoLC)968232060 | ||
| 035 | |a (DE-599)BVBBV043991049 | ||
| 040 | |a DE-604 |b ger |e rda | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-898 |a DE-M347 |a DE-859 |a DE-863 |a DE-20 |a DE-1051 |a DE-92 |a DE-862 | ||
| 082 | 0 | |a 005.74 |2 23 | |
| 084 | |a ST 271 |0 (DE-625)143639: |2 rvk | ||
| 100 | 1 | |a Carter, Peter A. |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a SQL Server AlwaysOn Revealed |c by Peter A. Carter |
| 250 | |a Second edition | ||
| 264 | 1 | |a Berkeley, CA |b Apress |c 2016 | |
| 300 | |a 1 Online-Ressource (XV, 212 Seiten) |b 112 Illustrationen (farbig) | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b c |2 rdamedia | ||
| 338 | |b cr |2 rdacarrier | ||
| 650 | 4 | |a Computer science | |
| 650 | 4 | |a Management information systems | |
| 650 | 4 | |a Computer organization | |
| 650 | 4 | |a Database management | |
| 650 | 4 | |a Computer Science | |
| 650 | 4 | |a Database Management | |
| 650 | 4 | |a Computer Systems Organization and Communication Networks | |
| 650 | 4 | |a Enterprise Architecture | |
| 650 | 4 | |a Informatik | |
| 650 | 0 | 7 | |a SQL Server |0 (DE-588)4343204-9 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Datenbanksystem |0 (DE-588)4113276-2 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a SQL |0 (DE-588)4134010-3 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Informatik |0 (DE-588)4026894-9 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a SQL |0 (DE-588)4134010-3 |D s |
| 689 | 0 | 1 | |a Datenbanksystem |0 (DE-588)4113276-2 |D s |
| 689 | 0 | |5 DE-604 | |
| 689 | 1 | 0 | |a Informatik |0 (DE-588)4026894-9 |D s |
| 689 | 1 | 1 | |a SQL Server |0 (DE-588)4343204-9 |D s |
| 689 | 1 | |8 1\p |5 DE-604 | |
| 776 | 0 | 8 | |i Erscheint auch als |n Druckausgabe |z 978-1-4842-2396-3 |
| 856 | 4 | 0 | |u https://doi.org/10.1007/978-1-4842-2397-0 |x Verlag |z URL des Erstveröffentlichers |3 Volltext |
| 856 | 4 | 2 | |m HBZ Datenaustausch |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=029399256&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 912 | |a ZDB-2-CWD | ||
| 940 | 1 | |q ZDB-2-CWD_2016 | |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-029399256 | ||
| 883 | 1 | |8 1\p |a cgwrk |d 20201028 |q DE-101 |u https://d-nb.info/provenance/plan#cgwrk | |
| 966 | e | |u https://doi.org/10.1007/978-1-4842-2397-0 |l FHM01 |p ZDB-2-CWD |x Verlag |3 Volltext | |
| 966 | e | |u https://doi.org/10.1007/978-1-4842-2397-0 |l FHN01 |p ZDB-2-CWD |x Verlag |3 Volltext | |
| 966 | e | |u https://doi.org/10.1007/978-1-4842-2397-0 |l FHO01 |p ZDB-2-CWD |x Verlag |3 Volltext | |
| 966 | e | |u https://doi.org/10.1007/978-1-4842-2397-0 |l FHR01 |p ZDB-2-CWD |x Verlag |3 Volltext | |
| 966 | e | |u https://doi.org/10.1007/978-1-4842-2397-0 |l FKE01 |p ZDB-2-CWD |x Verlag |3 Volltext | |
| 966 | e | |u https://doi.org/10.1007/978-1-4842-2397-0 |l FWS01 |p ZDB-2-CWD |x Verlag |3 Volltext | |
| 966 | e | |u https://doi.org/10.1007/978-1-4842-2397-0 |l FWS02 |p ZDB-2-CWD |x Verlag |3 Volltext | |
| 966 | e | |u https://doi.org/10.1007/978-1-4842-2397-0 |l UBW01 |p ZDB-2-CWD |x Verlag |3 Volltext | |
Datensatz im Suchindex
| DE-BY-FWS_katkey | 635069 |
|---|---|
| _version_ | 1806180624136929280 |
| adam_text | Titel: SQL server alwaysOn revealed
Autor: Carter, Peter
Jahr: 2016
Contents
J
About the Author xi
About the Technical Reviewer xiii
Acknowledgments xv
?Chapter 1: High Availability and Disaster Recovery Concepts 1
Level of Availability 1
Service-Level Agreements and Service-Level Objectives 3
Proactive Maintenance 4
Recovery Point Objective and Recovery Time Objective 4
Cost of Downtime 5
Classification of Standby Servers 6
Summary 7
?Chapter 2: Understanding High Availability and
Disaster Recovery Technologies 9
AlwaysOn Failover Clustering 9
Active/Active Configuration 11
Three-Plus Node Configurations 12
Quorum 13
Database Mirroring 15
AlwaysOn Availability Groups 18
Automatic Page Repair 22
vii
CONTENTS
no
Log Shipping
Recovery Modes ^
Remote Monitor Server 25
nc
Fai lover
Combining Technologies 25
Summary 27
?Chapter 3: Implementing a Cluster 29
Building the Cluster 30
Installing the Failover Cluster Feature 31
Creating the Cluster 37
Configuring the Cluster 48
Changing the Quorum 48
Configuring MSDTC 52
Configuring a Role 55
Summary 58
?Chapter 4: Implementing an AlwaysOn Failover
Clustered Instance 59
Building the Instance 59
Installing the Instance with PowerShell 76
Adding a Node 77
Adding a Node Using PowerShell 80
Summary 82
?Chapter 5: Implementing HA with AlwaysOn
Availability Groups 83
Preparing for Availability Groups 84
Configuring SQL Server 8g
Creating the Availability Group 90
viii
• CONTENTS
Using the New Availability Group Wizard 90
Scripting the Availability Group 100
Using the New Availability Group Dialog Box 109
Performance Considerations for Synchronous Commit Mode 112
Summary 119
^Chapter 6: Implementing DR with AlwaysOn
Availability Groups 121
Configuring the Cluster 121
Adding a Node 122
Modifying the Quorum 124
Adding an IP Address 128
Configuring the Availability Group 130
Adding and Configuring a Replica 131
Add an IP Address 139
Improving Connection Times 141
Distributed Availability Groups 142
Configuring Readable Secondary Replicas 144
Summary.... 147
ElChapter 7: Administering AlwaysOn 149
Managing a Cluster 149
Moving the Instance Between Nodes 149
Rolling Patch Upgrade 151
Removing a Node from the Cluster 153
Managing AlwaysOn Availability Groups 154
Failover 154
Synchronizing Uncontained Objects 161
Adding Multiple Listeners 161
Other Administrative Considerations 163
Summary.... 164
ix
CONTENTS
?Chapter 8: Monitoring AlwaysOn Availability Groups 167
AlwaysOn Dashboard 167
AlwaysOn Health Trace 170
Monitoring AlwaysOn with Extended Events 171
Extended Events Concepts 171
Creating an Event Session to Monitor Availability Group 183
Summary ....189
?Chapter 9: Troubleshooting AlwaysOn .....191
AlwaysOn Failover Clustered Instance Metadata 191
Discovering the Node That Hosts an Instance 191
Viewing Health Check Configuration 192
AlwaysOn Availability Group Metadata 196
Determining the Last Failover Reason 196
Assessing the State of Availability Databases 199
Summary 205
Index . 207
X
|
| any_adam_object | 1 |
| author | Carter, Peter A. |
| author_facet | Carter, Peter A. |
| author_role | aut |
| author_sort | Carter, Peter A. |
| author_variant | p a c pa pac |
| building | Verbundindex |
| bvnumber | BV043991049 |
| classification_rvk | ST 271 |
| collection | ZDB-2-CWD |
| ctrlnum | (ZDB-2-CWD)978-1-4842-2397-0 (OCoLC)968232060 (DE-599)BVBBV043991049 |
| dewey-full | 005.74 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.74 |
| dewey-search | 005.74 |
| dewey-sort | 15.74 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| doi_str_mv | 10.1007/978-1-4842-2397-0 |
| edition | Second edition |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>03181nmm a2200709zc 4500</leader><controlfield tag="001">BV043991049</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20170119 </controlfield><controlfield tag="007">cr|uuu---uuuuu</controlfield><controlfield tag="008">170110s2016 |||| o||u| ||||||eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781484223970</subfield><subfield code="c">Online</subfield><subfield code="9">978-1-4842-2397-0</subfield></datafield><datafield tag="024" ind1="7" ind2=" "><subfield code="a">10.1007/978-1-4842-2397-0</subfield><subfield code="2">doi</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ZDB-2-CWD)978-1-4842-2397-0</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)968232060</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV043991049</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-898</subfield><subfield code="a">DE-M347</subfield><subfield code="a">DE-859</subfield><subfield code="a">DE-863</subfield><subfield code="a">DE-20</subfield><subfield code="a">DE-1051</subfield><subfield code="a">DE-92</subfield><subfield code="a">DE-862</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.74</subfield><subfield code="2">23</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 271</subfield><subfield code="0">(DE-625)143639:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Carter, Peter A.</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">SQL Server AlwaysOn Revealed</subfield><subfield code="c">by Peter A. Carter</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">Second edition</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Berkeley, CA</subfield><subfield code="b">Apress</subfield><subfield code="c">2016</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource (XV, 212 Seiten)</subfield><subfield code="b">112 Illustrationen (farbig)</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Computer science</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Management information systems</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Computer organization</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Database management</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Computer Science</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Database Management</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Computer Systems Organization and Communication Networks</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Enterprise Architecture</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Informatik</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">SQL Server</subfield><subfield code="0">(DE-588)4343204-9</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Datenbanksystem</subfield><subfield code="0">(DE-588)4113276-2</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">SQL</subfield><subfield code="0">(DE-588)4134010-3</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Informatik</subfield><subfield code="0">(DE-588)4026894-9</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">SQL</subfield><subfield code="0">(DE-588)4134010-3</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">Datenbanksystem</subfield><subfield code="0">(DE-588)4113276-2</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="689" ind1="1" ind2="0"><subfield code="a">Informatik</subfield><subfield code="0">(DE-588)4026894-9</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" ind2="1"><subfield code="a">SQL Server</subfield><subfield code="0">(DE-588)4343204-9</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" ind2=" "><subfield code="8">1\p</subfield><subfield code="5">DE-604</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druckausgabe</subfield><subfield code="z">978-1-4842-2396-3</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="u">https://doi.org/10.1007/978-1-4842-2397-0</subfield><subfield code="x">Verlag</subfield><subfield code="z">URL des Erstveröffentlichers</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">HBZ Datenaustausch</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=029399256&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-2-CWD</subfield></datafield><datafield tag="940" ind1="1" ind2=" "><subfield code="q">ZDB-2-CWD_2016</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-029399256</subfield></datafield><datafield tag="883" ind1="1" ind2=" "><subfield code="8">1\p</subfield><subfield code="a">cgwrk</subfield><subfield code="d">20201028</subfield><subfield code="q">DE-101</subfield><subfield code="u">https://d-nb.info/provenance/plan#cgwrk</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://doi.org/10.1007/978-1-4842-2397-0</subfield><subfield code="l">FHM01</subfield><subfield code="p">ZDB-2-CWD</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://doi.org/10.1007/978-1-4842-2397-0</subfield><subfield code="l">FHN01</subfield><subfield code="p">ZDB-2-CWD</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://doi.org/10.1007/978-1-4842-2397-0</subfield><subfield code="l">FHO01</subfield><subfield code="p">ZDB-2-CWD</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://doi.org/10.1007/978-1-4842-2397-0</subfield><subfield code="l">FHR01</subfield><subfield code="p">ZDB-2-CWD</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://doi.org/10.1007/978-1-4842-2397-0</subfield><subfield code="l">FKE01</subfield><subfield code="p">ZDB-2-CWD</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://doi.org/10.1007/978-1-4842-2397-0</subfield><subfield code="l">FWS01</subfield><subfield code="p">ZDB-2-CWD</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://doi.org/10.1007/978-1-4842-2397-0</subfield><subfield code="l">FWS02</subfield><subfield code="p">ZDB-2-CWD</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://doi.org/10.1007/978-1-4842-2397-0</subfield><subfield code="l">UBW01</subfield><subfield code="p">ZDB-2-CWD</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield></record></collection> |
| id | DE-604.BV043991049 |
| illustrated | Not Illustrated |
| indexdate | 2024-08-01T12:27:51Z |
| institution | BVB |
| isbn | 9781484223970 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-029399256 |
| oclc_num | 968232060 |
| open_access_boolean | |
| owner | DE-898 DE-BY-UBR DE-M347 DE-859 DE-863 DE-BY-FWS DE-20 DE-1051 DE-92 DE-862 DE-BY-FWS |
| owner_facet | DE-898 DE-BY-UBR DE-M347 DE-859 DE-863 DE-BY-FWS DE-20 DE-1051 DE-92 DE-862 DE-BY-FWS |
| physical | 1 Online-Ressource (XV, 212 Seiten) 112 Illustrationen (farbig) |
| psigel | ZDB-2-CWD ZDB-2-CWD_2016 |
| publishDate | 2016 |
| publishDateSearch | 2016 |
| publishDateSort | 2016 |
| publisher | Apress |
| record_format | marc |
| spellingShingle | Carter, Peter A. SQL Server AlwaysOn Revealed Computer science Management information systems Computer organization Database management Computer Science Database Management Computer Systems Organization and Communication Networks Enterprise Architecture Informatik SQL Server (DE-588)4343204-9 gnd Datenbanksystem (DE-588)4113276-2 gnd SQL (DE-588)4134010-3 gnd Informatik (DE-588)4026894-9 gnd |
| subject_GND | (DE-588)4343204-9 (DE-588)4113276-2 (DE-588)4134010-3 (DE-588)4026894-9 |
| title | SQL Server AlwaysOn Revealed |
| title_auth | SQL Server AlwaysOn Revealed |
| title_exact_search | SQL Server AlwaysOn Revealed |
| title_full | SQL Server AlwaysOn Revealed by Peter A. Carter |
| title_fullStr | SQL Server AlwaysOn Revealed by Peter A. Carter |
| title_full_unstemmed | SQL Server AlwaysOn Revealed by Peter A. Carter |
| title_short | SQL Server AlwaysOn Revealed |
| title_sort | sql server alwayson revealed |
| topic | Computer science Management information systems Computer organization Database management Computer Science Database Management Computer Systems Organization and Communication Networks Enterprise Architecture Informatik SQL Server (DE-588)4343204-9 gnd Datenbanksystem (DE-588)4113276-2 gnd SQL (DE-588)4134010-3 gnd Informatik (DE-588)4026894-9 gnd |
| topic_facet | Computer science Management information systems Computer organization Database management Computer Science Database Management Computer Systems Organization and Communication Networks Enterprise Architecture Informatik SQL Server Datenbanksystem SQL |
| url | https://doi.org/10.1007/978-1-4842-2397-0 http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=029399256&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT carterpetera sqlserveralwaysonrevealed |