Buy new:
$44.99$44.99
Arrives:
Friday, Nov 17
Ships from: Amazon.com Sold by: Amazon.com
Buy used: $40.36
Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet, or computer - no Kindle device required.
Read instantly on your browser with Kindle for Web.
Using your mobile phone camera - scan the code below and download the Kindle app.
Virtualizing SQL Server with VMware: Doing it Right (Vmware Press Technology) 1st Edition
| Price | New from | Used from |
- Kindle
$35.99 Read with our free app - Paperback
$40.36 - $44.9911 Used from $3.93 4 New from $42.93
Purchase options and add-ons
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
- ISBN-100321927753
- ISBN-13978-0321927750
- Edition1st
- PublisherVMware Press
- Publication dateJuly 25, 2014
- LanguageEnglish
- Dimensions7 x 1.15 x 9.13 inches
- Print length508 pages
Editorial Reviews
About the Author
Michael Corey (@Michael_Corey) is the President of Ntirety, a division of Hosting. Michael is an experienced entrepreneur and a recognized expert on relational databases, remote database administration, and data warehousing. Microsoft named Michael a SQL
Server MVP, VMware named him a vExpert, and Oracle named him an Oracle Ace. Michael has presented at technical and business conferences from Brazil to Australia. Michael is a past president of the Independent Oracle Users Group; he helped found the Professional Association of SQL Server, is a current board member of the IOUG Cloud SIG, and is actively involved in numerous professional associations and industry user groups. Michael currently sits on the executive committee for the Massachusetts Robert H. Goddard Council for Science, Technology, Engineering, and Mathematics.
Jeff Szastak (@Szastak) is currently a Staff Systems Engineer for VMware. Jeff has been with VMware for over six years, holding various roles with VMware during his tenure. These roles have included being a TAM, Systems Engineer Specialist for Business-Critical Applications, Enterprise Healthcare Systems Engineer, and a CTO Ambassador. Jeff is a recognized expert for virtualizing databases and other high I/O applications on the vSphere platform. Jeff is a regular speaker at VMworld, VMware Partner Exchange, VMware User Groups, and has spoken at several SQL PASS events. Jeff holds a Master of Information Assurance degree as well as the distinguished CISSP certification. Jeff has over 13 &;lucky&; years in IT and is passionate about helping others find a better way to do IT.
Michael Webster (@vcdxnz001) is based in Auckland, New Zealand. He is a VMware Certified Design Expert (VCDX #66), author of longwhiteclouds. com (a top-15 virtualization blog), and a Top 10 Vmworld Session Speaker for 2013. In addition, he is a Senior Solutions and Performance Engineer for Nutanix, vExpert, MCSE, and NPP. Michael specializes in solution architecture and performance engineering for Unix-to-VMware migrations as well as virtualizing business-critical applications such as SQL, Oracle, SAP, Exchange, Enterprise Java Systems, and monster VMs in software-defined data centers. Michael has more than 20 years experience in the IT industry and 10 years experience deploying VMware solutions in large-scale environments around the globe. He is regularly a presenter at VMware VMworld, VMware vForums, VMware User Groups, and other industry events. In addition to this book, Michael was technical reviewer of VCDX Boot Camp and Virtualizing and Tuning Large-Scale Java Platforms, both published by VMware Press.
Product details
- Publisher : VMware Press; 1st edition (July 25, 2014)
- Language : English
- Paperback : 508 pages
- ISBN-10 : 0321927753
- ISBN-13 : 978-0321927750
- Item Weight : 1.76 pounds
- Dimensions : 7 x 1.15 x 9.13 inches
- Best Sellers Rank: #3,593,428 in Books (See Top 100 in Books)
- #1,366 in Database Storage & Design
- #4,002 in Computer & Technology Certification Guides
- #7,734 in Databases & Big Data
- Customer Reviews:
Important information
To report an issue with this product, click here.
About the authors

More than 20 years in the IT industry and 10 years experience deploying VMware solutions in large scale environments around the globe. Senior Solutions and Performance Engineer for Nutanix, VCDX-066, vExpert, MCSE, Nutanix Platform Professional. Co-Author of Virtualizing SQL Server on VMware: Doing It Right (VMware Press), Author of longwhiteclouds.com (top15 virtualisation blog), Top 10 VMworld Session Speaker 2013. Specializes in solution architecture and performance engineering for Unix to VMware migrations, and virtualizing business critical applications such as Oracle, SAP, SQL, Exchange, Java in software-defined datacenters. He is regularly presenter at VMware VMworld, VMware vForums, VMware User Groups and other industry events. Improving the world with Web Scale IT for the masses to reduce cost and complexity.

Discover more of the author’s books, see similar authors, read author blogs and more

Michael is co-founder of LicenseFortress. In 2015 & 2017, identified as #42 of the top 100 most influential people in the “cloud industry”. Michael's a recognized Microsoft Data Platform MVP formerly (Microsoft SQL Server MVP), recognized Oracle ACE, a recognized VMware vExpert and has worked with relational databases for over 30 years starting with Oracle Version 3. Michael is the original Oracle Press author, Author for VMware Press, frequent blogger http://michaelcorey.com/, a regular columnist for the Big Data Quarterly and his newest book is Virtualizing SQL Server with VMware: Doing IT Right from VMware Press.
Michael is the Current President of the IOUG VMware, Past President Independent Oracle Users Group and a Founder of the Professional Association of SQL Server.
Michael has presented at Technical & Business conferences from Brazil to Austraila Forbes Website recently wrote an article "21 Questions To Ask Your Cloud Computing Provider, Before You Sign" based upon a recent presentation Michael gave.
Customer reviews
Customer Reviews, including Product Star Ratings help customers to learn more about the product and decide whether it is the right product for them.
To calculate the overall star rating and percentage breakdown by star, we don’t use a simple average. Instead, our system considers things like how recent a review is and if the reviewer bought the item on Amazon. It also analyzed reviews to verify trustworthiness.
Learn more how customers reviews work on Amazon-
Top reviews
Top reviews from the United States
There was a problem filtering reviews right now. Please try again later.
"Virtualizing SQL Server with VMware" closes that gap. And while it is NOT a VMware training book per se (VMware and SQL are too complex for 500 pages ) the book "married" both concepts beautifully and provides tons of tips for the experienced MS-SQL DBA.
The book focuses on the design phase. It explains the importance of proper SAN and disk configuration, RAM settings and how VMware handles all that.
You won't find tips to tune up queries or to troubleshoot VMware if things go wrong. The author also assumes that you have some basic knowledge of Windows operating system, networking and SQL 2012 internals like memory management.
To me, the two most interesting chapters are the one for Storage and Memory configuration. The author explains how VMware handles memory , which is totally different from a physical machine, and why and how certain SQL server settings memory may affect or improve performance when running a database on a virtual environment.
If you have no previous exposure to VMware, I do recommend you to read Virtualization Essentials by Matthew Portnoy and Mastering VMware by Scott Lowe. The 1st one is an intro book to Virtualization; the second one is a cert. book and goes more in detail about VMware setup, settings and management.
Avoid this book if you are an entry level MS-SQL DBA or if you need to setup VMware from scratch. Those initial setup steps are no mentioned here and you will need additional resources if you intention is to learn that.
Page 309 - the high availability chart shows pre-SQL-2012 clustering and SQL-2012+ clustering as having different recovery point objectives. (They don't - they just have different marketing names.) It says database mirroring, AlwaysOn Availability Groups, and failover clusters fail over in less than three seconds - that's just not realistic. It says you can do vMotion on a database mirror - that's not realistic either, because synchronous mirrors often fail over during long vMotions.
Those errors are all on just one page, in one chart, and it just keeps coming.
Page 111 says that if you put your log files on local SSDs, you should "have an additional copy on SAN." That's just not even physically possible with SQL Server - you can have two log files, but if either of them fails, your database is down. This concept is possible in Oracle, and the authors' Oracle background keeps showing up throughout the book. They recommend things that work in Oracle, but not in SQL Server.
Page 111 also says that Microsoft recommends 1 data file per CPU core and .25 to 1 user database. That was true in 2005-2006, but Microsoft has since released multiple knowledge base articles like KB2154845 that have better guidance.
I could go on and on (and in my book review on BrentOzar dot com, I do) but the bottom line is that you should wait for the next revision of this book. The first edition has too many technical problems.