商品描述
Get a fast start to using AlwaysOn, the SQL Server solution to high-availability and disaster recovery. This second edition is newly-updated to cover the 2016 editions of both SQL Server and Windows Server. Also in this edition is all-new content on troubleshooting and metadata. The book provides a solid and accurate understanding of how to implement systems requiring consistent and continuous uptime, as well as how to troubleshoot those systems in order to keep them running an reliable.
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 in SQL Server 2016
- Build and configure a Windows Cluster
- Create and configure an AlwaysOn failover clustered instance
- Implement AlwaysOn Availability Groups and appropriately configure them
- Administer AlwaysOn technologies post implementation
- Troubleshoot and resolve problems with misbehaving systems
Who This Book Is For
Database administrators interested in growing their knowledge and skills in Microsoft SQL Server’s high-availability and disaster recovery feature set.
商品描述(中文翻譯)
快速入門使用AlwaysOn，這是SQL Server的高可用性和災難恢復解決方案。本書第二版已更新至SQL Server和Windows Server的2016版本。此外，本版還新增了有關故障排除和元數據的全新內容。本書提供了實施需要持續運行和連續正常運行時間的系統的堅實且準確的理解，以及如何排除這些系統以保持其可靠運行。
首先介紹高可用性和災難恢復概念，如恢復點目標（RPO）、恢復時間目標（RTO）、可用性級別和停機成本。然後詳細介紹實施和配置AlwaysOn功能集以滿足組織設定的業務目標。
《SQL Server AlwaysOn Revealed》提供了實際建議，教導您如何構建和配置最適合的拓撲結構，以滿足高可用性和災難恢復的要求。內容包括實施叢集、構建AlwaysOn故障轉移叢集實例以及配置AlwaysOn可用性組。這是一本實用且實踐的書籍，讓您快速入門使用最為熱門的SQL Server功能集之一。
本書教授使用AlwaysOn功能集構建高可用性和災難恢復解決方案，提供了有關配置和性能考慮的實際建議，演示了AlwaysOn功能集的管理技術。
您將學到以下內容：
- 了解SQL Server 2016中的高可用性和災難恢復
- 構建和配置Windows叢集
- 創建和配置AlwaysOn故障轉移叢集實例
- 實施AlwaysOn可用性組並適當配置它們
- 實施AlwaysOn技術後的管理
- 排除和解決系統故障的問題
本書適合對Microsoft SQL Server高可用性和災難恢復功能集的知識和技能有興趣的數據庫管理員。
