VMware虚拟化SQL Server实战指南：无水印PDF

需积分: 8 17 浏览量更新于2024-07-19 收藏 25.75MB PDF 举报

"Virtualizing SQL Server with VMware Doing IT Right" 是一本关于如何在VMware环境中有效虚拟化SQL Server的英文原著PDF。这本书详细介绍了如何在VMware平台上实现SQL Server的高效和稳定运行，提供了最佳实践和专业指导。在虚拟化SQL Server时，VMware是一个常用的平台，因为它能够提供灵活的资源分配、高可用性和灾难恢复解决方案。本书可能涵盖了以下关键知识点： 1. **虚拟化基础**：首先，书中可能会讲解虚拟化的概念，包括虚拟机（VM）的工作原理、资源分配（如CPU、内存、磁盘和网络）以及虚拟化层如何抽象物理硬件。 2. **SQL Server性能优化**：虚拟环境中的SQL Server性能优化是重点。可能包括如何配置虚拟机设置以最大化数据库性能，例如合理分配vCPU数量、内存大小以及I/O子系统的配置。 3. **存储规划与设计**：书中可能讨论了针对SQL Server的最佳存储配置，包括RAID级别选择、存储区域网络（SAN）或网络附加存储（NAS）的使用，以及存储性能监控和调优。 4. **高可用性与灾难恢复**：VMware的高可用性（HA）和容错（FT）功能如何应用于SQL Server，以及如何设置故障转移群集和镜像以确保业务连续性。 5. **备份与恢复策略**：虚拟环境下的备份策略与物理环境不同，书里可能会介绍如何利用VMware工具进行备份，以及如何执行灾难恢复计划。 6. **监控与性能分析**：书中可能涵盖如何使用VMware工具（如vSphere Client和vCenter Server）以及SQL Server自带的性能监视器来跟踪和分析SQL Server和虚拟机的性能。 7. **安全性和合规性**：虚拟化对SQL Server的安全性有特定要求，包括虚拟机的隔离、安全配置、访问控制和数据加密。 8. **最佳实践和案例研究**：作者可能分享了一些成功实施虚拟化SQL Server的案例，总结了最佳实践，帮助读者避免常见陷阱。 9. **更新和升级策略**：如何在虚拟环境中进行SQL Server的版本升级和补丁管理，同时保持服务的稳定性。 10. **自动化和脚本化**：利用VMware的自动化工具（如PowerCLI）来管理SQL Server虚拟机，实现部署、扩展和维护的自动化。为了充分利用此书，读者应具备一定的VMware和SQL Server基础知识。阅读时，可以调整电子书的显示设置以优化代码和配置示例的呈现。如果遇到代码格式可能因重排而受损的情况，可以通过点击链接查看原始的代码图像，以保持与印刷版的对应一致性。

Lack of Background Noise
Failure to Considering Single Compute Unit Performance
Blended Peaks of Multiple Systems
vMotion Slot Sizes of Monster Database Virtual Machines
Summary
11 Configuring a Performance Test—From Beginning to End
Introduction
What We Used—Software
What You Will Need—Computer Names and IP Addresses
Additional Items for Consideration
Getting the Lab Up and Running
VMDK File Configuration
VMDK File Configuration Inside Guest Operating System
Memory Reservations
Enabling Hot Add Memory and Hot Add CPU
Affinity and Anti-Affinity Rules
Validate the Network Connections
Configuring Windows Failover Clustering
Setting Up the Clusters
Validate Cluster Network Configuration
Changing Windows Failover Cluster Quorum Mode
Installing SQL Server 2012
Configuration of SQL Server 2012 AlwaysOn Availability Groups
Configuring the Min/Max Setting for SQL Server
Enabling Jumbo Frames
Creating Multiple tempdb Files
Creating a Test Database
Creating the AlwaysOn Availability Group
Installing and Configuring Dell DVD Store
Running the Dell DVD Store Load Test
Summary
Appendix A Additional Resources

Foreword

About 10 years ago, I started a new job. The company I started working for had a

couple hundred physical servers at the time. When several new internal software

development projects started, we needed to expand quickly and added dozens of new

physical servers. Pretty soon we started hitting all the traditional datacenter problems,

such as lack of floor space, high power consumption, and cooling constraints. We had to

solve our problems, and during our search for a solution we were introduced to a new

product called VMware ESX and Virtual Center. It didn’t take long for us to see the

potential and to start virtualizing a large portion of our estate.

During this exercise, we started receiving a lot of positive feedback on the performance

of the virtualized servers. On top of that, our application owners loved the fact that we

could deploy a new virtual machine in hours instead of waiting weeks for new

hardware to arrive. I am not even talking about all the side benefits, such as VMotion

(or vMotion, as we call it today) and VMware High Availability, which provided a

whole new level of availability and enabled us to do maintenance without any

downtime for our users.

After the typical honeymoon period, the question arose: What about our database

servers? Could this provide the same benefits in terms of agility and availability while

maintaining the same performance? After we virtualized the first database server, we

quickly realized that just using VMware Converter and moving from physical to virtual

was not sufficient, at least not for the databases we planned to virtualize.

To be honest, we did not know much about the database we were virtualizing. We

didn’t fully understand the CPU and memory requirements, nor did we understand the

storage requirements. We knew something about the resource consumption, but how do

you make a design that caters to those requirements? Perhaps even more importantly,

where do you get the rest of the information needed to ensure success?

Looking back, I wish we’d had guidance in any shape or form that could have helped

along our journey—guidance that would provide tips about how to gather requirements,

how to design an environment based on these requirements, how to create a

performance baseline, and what to look for when hitting performance bottlenecks.

That is why I am pleased Jeff Szastak, Michael Corey, and Michael Webster took the

time to document the valuable lessons they have learned in the past few years about

virtualizing tier 1 databases and released it through VMware Press in the form of this

book you are about to read. Having gone through the exercise myself, and having made

all the mistakes mentioned in the book, I think I am well qualified to urge you to soak in

all this valuable knowledge to ensure success!

Duncan Epping

Preface

As we traveled the globe presenting on how to virtualize the most demanding business-

critical applications, such as SQL Server, Oracle, Microsoft Exchange, and SAP, it

became very clear that there was a very real and unmet need from the attendees to learn

how to virtualize these most demanding applications correctly.

This further hit home when we presented at the VMworld conferences in San Francisco

and Barcelona. At each event, we were assigned a very large room that held over 1,800

people; within 48 hours of attendees being able to reserve a seat in the room, it was

filled to capacity. We were then assigned a second large room that again filled up

within 24 hours.

Recognizing that the information we had among the three of us could help save countless

others grief, we decided to collaborate on this very practical book.

Target Audience

Our goal was to create in one book—a comprehensive resource that a solution architect,

system administrator, storage administrator, or database administrator could use to

guide them through the necessary steps to successfully virtualize a database. Many of the

lessons learned in this book apply to any business-critical application being virtualized

from SAP, E-Business Suite, Microsoft Exchange, or Oracle, with the specific focus of

this book on Microsoft SQL Server. Although you don’t have to be a database

administrator to understand the contents of this book, it does help if you are technical

and have a basic understanding of vSphere.

Approach Taken

Everything you need to succeed in virtualizing SQL Server can be found within the

pages of this book. By design, we created the book to be used in one of two ways. If you

are looking for a comprehensive roadmap to virtualize your mission-critical databases,

then follow along in the book, chapter by chapter. If you are trying to deal with a

particular resource that is constraining the performance of your database, then jump to

Chapters 5 through 8.

At a high level, the book is organized as follows:

Chapters 1 and 2 explain what virtualization is and the business case for it. If you

are a database administrator or new to virtualization, you will find these chapters

very helpful; they set the stage for why virtualizing your databases is “doing IT

right.”

Chapters 3 through 9 are the roadmap you can follow to successfully virtualize the

most demanding of mission-critical databases. Each chapter focuses on a

剩余554页未读，继续阅读

yinkaisheng-nj

粉丝: 762
资源: 6231

VMware虚拟化SQL Server实战指南：无水印PDF

Virtualizing SQL Server with VMware Doing IT Right mobi

Virtualizing SQL Server with VMware Doing IT Right epub

wpf datagrid 大数据量

wpf datagrid ui线程卡顿

wpf devexpress 的gridcontrol怎么添加滚动条

如何通过代码优化WPF TabControl的切换性能？

winform重置窗体布局特别卡顿

wpf 动态表格缓存启来

python中paramiko插件

fastcache-1.1.0-cp38-cp38-win_amd64.whl

最新资源