Virtualizing SQL Server with VMware: Doing IT Right (Paperback)

Michael Corey, Jeff Szastak, Michael Webster

買這商品的人也買了...

商品描述

The start-to-finish guide to virtualizing business-critical SQL Server databases on VMware vSphere 5

 

By virtualizing business-critical databases, enterprises can drive far more value from existing IT infrastructure. But squeezing maximum performance out of a virtualized database instance is an art as much as a science. This indispensable start-to-finish guide brings together all the techniques, tips, and insights you need to succeed.

 

Drawing on unsurpassed personal experience, three leading experts share complete best practices for deploying business-critical database servers in virtualized vSphere 5 environments. They cover the entire project lifecycle, bridging technical and communications gaps between SQL Server and VMware professionals that often make database virtualization more difficult than it needs to be.

 

You’ll find specific guidance for architects and administrators responsible for systems, storage, databases, applications, or VMware virtualization. The authors also present detailed, start-to-finish coverage of performance baselining and testing: all you need to make your virtualized databases as fast as they are cost effective. Although this book focuses on SQL, the authors’ proven guidance for enhancing performance can be leveraged by any IT professional virtualizing a demanding Tier 1 application.

 

Coverage includes

 

     •    Business cases for database virtualization: consolidation, Database as a Service (DaaS), efficiency, and “SLAs on steroids”

     •    Using the redundancy inherent in virtualization  to improve availability

     •    Constructing a careful, conservative implementation plan

     •    Balancing disk, CPU, memory, and network for superior performance

     •    Mastering the five key principles of database storage design

     •    Leveraging memory: SQL MAX, page locking, NUMA, reservations, swapping, large memory pages, and more

     •    Ensuring responsiveness by providing a fast, reliable, low-latency network

     •    Supporting advanced AlwaysOn Failover Cluster Instances and Availability Groups

     •    Baselining physical systems and properly determining resource requirements

     •    Configuring performance tests from beginning  to end

     •    Migrating existing SQL Server databases  onto a vSphere platform

     •    Avoiding traps and pitfalls in virtualizing production databases

     •    Managing and monitoring virtualized database instances and resources

 

 

商品描述(中文翻譯)

這是一本關於在VMware vSphere 5上虛擬化關鍵業務SQL Server資料庫的從頭到尾指南。

通過虛擬化關鍵業務資料庫,企業可以從現有的IT基礎設施中獲得更多價值。但是,從虛擬化的資料庫實例中獲得最大性能是一門藝術,也是一門科學。這本不可或缺的從頭到尾指南匯集了您成功所需的所有技巧、提示和見解。

三位領先專家根據自己無與倫比的個人經驗,分享了在虛擬化vSphere 5環境中部署關鍵業務資料庫伺服器的完整最佳實踐。他們涵蓋了整個專案生命週期,彌合了SQL Server和VMware專業人員之間的技術和溝通差距,這往往使得資料庫虛擬化變得比必要的困難。

本書針對負責系統、儲存、資料庫、應用程式或VMware虛擬化的架構師和管理員提供了具體的指導。作者還詳細介紹了性能基準和測試的從頭到尾覆蓋範圍:這是您使虛擬化的資料庫既快速又具有成本效益所需的一切。儘管本書專注於SQL,但作者對提高性能的成熟指導可以被任何虛擬化要求嚴格的一級應用程式的IT專業人員所利用。

內容包括:

- 資料庫虛擬化的業務案例:整合、資料庫即服務(DaaS)、效率和「超強服務等級協議」
- 利用虛擬化中固有的冗餘性提高可用性
- 構建謹慎、保守的實施計劃
- 平衡磁碟、CPU、記憶體和網路以獲得卓越性能
- 掌握資料庫儲存設計的五個關鍵原則
- 利用記憶體:SQL MAX、頁鎖定、NUMA、保留、交換、大記憶體頁等
- 通過提供快速、可靠、低延遲的網路確保響應能力
- 支援高級AlwaysOn Failover Cluster Instances和可用性群組
- 基準物理系統並正確確定資源需求
- 從頭到尾配置性能測試
- 將現有的SQL Server資料庫遷移到vSphere平台
- 避免在虛擬化生產資料庫時的陷阱和問題
- 管理和監控虛擬化的資料庫實例和資源