Deliver to your Kindle or other device

 
 
 

Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Sorry, this item is not available in
Image not available for
Colour:
Image not available
 

Virtualizing SQL Server with VMware: Doing IT Right (VMware Press Technology) [Kindle Edition]

Michael Corey , Jeff Szastak , Michael Webster
5.0 out of 5 stars  See all reviews (1 customer review)

Print List Price: £27.99
Kindle Price: £14.30 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: £13.69 (49%)
* Unlike print books, digital books are subject to VAT.

Free Kindle Reading App Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.

To get the free app, enter your e-mail address or mobile phone number.

Formats

Amazon Price New from Used from
Kindle Edition £14.30  
Paperback £23.79  
Kindle Delivers Sign-up to receive email updates and get a Free Kindle Book

Book Description

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

 

 



Product Description

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

  • Format: Kindle Edition
  • File Size: 33616 KB
  • Print Length: 512 pages
  • Simultaneous Device Usage: Up to 5 simultaneous devices, per publisher limits
  • Publisher: VMware Press; 1 edition (23 July 2014)
  • Sold by: Amazon Media EU S.à r.l.
  • Language: English
  • ASIN: B00M1SJ3OS
  • Text-to-Speech: Enabled
  • X-Ray:
  • Word Wise: Not Enabled
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (1 customer review)
  • Amazon Bestsellers Rank: #90,471 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?


More About the Authors

Discover books, learn about writers, and more.

What Other Items Do Customers Buy After Viewing This Item?


Customer Reviews

4 star
0
3 star
0
2 star
0
1 star
0
5.0 out of 5 stars
5.0 out of 5 stars
Most Helpful Customer Reviews
5.0 out of 5 stars Five Stars 19 Mar. 2015
By penben
Format:Paperback|Verified Purchase
Worth every penny
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 4.3 out of 5 stars  13 reviews
232 of 240 people found the following review helpful
1.0 out of 5 stars Do not buy this book. 20 Aug. 2014
By Brent Ozar - Published on Amazon.com
Format:Paperback|Verified Purchase
This book is simply not factually correct on a large number of issues.

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.
4 of 4 people found the following review helpful
5.0 out of 5 stars Fits right into my VCDX library 5 Oct. 2014
By Niran even chen - Published on Amazon.com
Format:Paperback
This book is a great resource for anyone interested in SQL virtualization or generally database virtualization as many of the concepts from the virtualization side are the same for all databases. The book is constructed very logically and starts from very basic explanation of the business case for virtualizing SQL and explanations about virtualization in general, this is very important for DBAs who are not fermiliar with virtualization concepts, from chapters 4-5 the book starts to dig deeper into both virtualization concepts and SQL concepts weaving them together to paint a full picture that is needed for both IT virtualization admins and architects and also to DB admins. The leading theme is performance design which is natural as that is the main concern of DBAs that are virtualizing their database, they ask "will my da database perform well on virtual? l", by explaining how it works under the hood and combining in SQL specific configurations and best practices a DBA can feel more comfortable with the change. If your organization like a lot of other organizations today is taking the path of virtualizing critical SQL servers this book is a must read. For me it fits right into my VCDX resources nicely.
27 of 38 people found the following review helpful
1.0 out of 5 stars Save your money 21 Aug. 2014
By AKamble - Published on Amazon.com
Format:Paperback
I was reading this book before Brent Ozar put out his review and I whole heartedly agree with his remarks. When I started I thought it was me; but I now know it's not me. My suggestion for working with this book, do a read along with your resident VMWare / SAN expert sitting next to you. Some of the technical stuff is a bit questionable and it would be nice to have a expert point out the flaws first hand. The book is peppered with too many vendor URLs to read for my taste, after a while I thought I was reading a blog posting, not a authored and edited technical book.

VMWare Press you have a book in the works detailing on how to setup Oracle on VMWare, I am hopeful your team does a better job on that edition.
2 of 2 people found the following review helpful
5.0 out of 5 stars Great Reference Resource 2 Nov. 2014
By DS785 - Published on Amazon.com
Format:Paperback|Verified Purchase
This good goes into great depth about the entire virtualization stack as it pertains to Microsoft SQL server. It covers networking, storage, compute, and a whole host of SQL configuration options. While preparing for an upcoming SQL migration and remediation project I found the information extremely useful and relevant. It's a one stop shop for getting the low down on how to make SQL perform well in a VMware environment. If you want to ensure your SQL servers run optimally on VMware vSphere, then get this book and start reading.
4 of 5 people found the following review helpful
5.0 out of 5 stars Best in class comprehensive resource for virtualizing SQL Server 25 Sept. 2014
By SublimeRide - Published on Amazon.com
Format:Paperback
This book is chock-full of very detailed and useful information on virtualizing MS SQL databases. Some books and articles fall short by providing just enough information to get a DBA part way to a complete solution. This book goes extremely deep, with very specific configuration recommendations at every level of the infrastructure stack.

One of the key items I like about a good technical book is the ability to use it not just for learning, but also as a quick reference. This book serves both purposes well.

Overall, this is one of those must-have books in the technical library.
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Look for similar items by category