Es wird kein Kindle Gerät benötigt. Laden Sie eine der kostenlosen Kindle Apps herunter und beginnen Sie, Kindle-Bücher auf Ihrem Smartphone, Tablet und Computer zu lesen.

  • Apple
  • Android
  • Windows Phone
  • Android

Geben Sie Ihre Mobiltelefonnummer ein, um die kostenfreie App zu beziehen.

Kindle-Preis: EUR 23,19
inkl. MwSt.

Diese Aktionen werden auf diesen Artikel angewendet:

Einige Angebote können miteinander kombiniert werden, andere nicht. Für mehr Details lesen Sie bitte die Nutzungsbedingungen der jeweiligen Promotion.

An Ihren Kindle oder ein anderes Gerät senden

An Ihren Kindle oder ein anderes Gerät senden

Facebook Twitter Pinterest
Virtualizing SQL Server with VMware: Doing IT Right (VMware Press Technology) von [Corey, Michael, Szastak, Jeff, Webster, Michael]
Anzeige für Kindle-App

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


Alle Formate und Ausgaben anzeigen Andere Formate und Ausgaben ausblenden
Preis
Neu ab Gebraucht ab
Kindle Edition
"Bitte wiederholen"
EUR 23,19

Der lange Kindle-Lesesommer
Neu: Der lange Kindle-Lesesommer
Wir feiern die schönste Jahreszeit mit 30 Top-eBooks und einem Preisvorteil von mindestens 50%. Wir wünschen viel Freude mit Ihrer neuen Sommerlektüre. Jetzt entdecken

Produktbeschreibungen

Kurzbeschreibung

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

 

 

Über den Autor und weitere Mitwirkende

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."

Produktinformation

  • Format: Kindle Edition
  • Dateigröße: 41695 KB
  • Seitenzahl der Print-Ausgabe: 494 Seiten
  • Gleichzeitige Verwendung von Geräten: Bis zu 5 Geräte gleichzeitig, je nach vom Verlag festgelegter Grenze
  • Verlag: VMware Press; Auflage: 1 (23. Juli 2014)
  • Verkauf durch: Amazon Media EU S.à r.l.
  • Sprache: Englisch
  • ASIN: B00M1SJ3OS
  • Text-to-Speech (Vorlesemodus): Aktiviert
  • X-Ray:
  • Word Wise: Nicht aktiviert
  • Verbesserter Schriftsatz: Aktiviert
  • Durchschnittliche Kundenbewertung: Schreiben Sie die erste Bewertung
  • Amazon Bestseller-Rang: #352.322 Bezahlt in Kindle-Shop (Siehe Top 100 Bezahlt in Kindle-Shop)

  •  Ist der Verkauf dieses Produkts für Sie nicht akzeptabel?

Kundenrezensionen

Es gibt noch keine Kundenrezensionen auf Amazon.de
5 Sterne
4 Sterne
3 Sterne
2 Sterne
1 Stern

Die hilfreichsten Kundenrezensionen auf Amazon.com (beta)

Amazon.com: HASH(0x95dfe888) von 5 Sternen 15 Rezensionen
263 von 273 Kunden fanden die folgende Rezension hilfreich
HASH(0x95e28234) von 5 Sternen Do not buy this book. 20. August 2014
Von Brent Ozar - Veröffentlicht auf Amazon.com
Format: Taschenbuch Verifizierter Kauf
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.
30 von 41 Kunden fanden die folgende Rezension hilfreich
HASH(0x95e33e7c) von 5 Sternen Save your money 21. August 2014
Von AKamble - Veröffentlicht auf Amazon.com
Format: Taschenbuch
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.
5 von 6 Kunden fanden die folgende Rezension hilfreich
HASH(0x95e33d80) von 5 Sternen Fits right into my VCDX library 5. Oktober 2014
Von Niran even chen - Veröffentlicht auf Amazon.com
Format: Taschenbuch
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.
4 von 5 Kunden fanden die folgende Rezension hilfreich
HASH(0x95e3c168) von 5 Sternen Best in class comprehensive resource for virtualizing SQL Server 25. September 2014
Von SublimeRide - Veröffentlicht auf Amazon.com
Format: Taschenbuch
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.
7 von 10 Kunden fanden die folgende Rezension hilfreich
HASH(0x95e3c30c) von 5 Sternen If you are a VM admin (not just VMware), buy this book now. Period. 18. Februar 2015
Von David A. Klee Jr. - Veröffentlicht auf Amazon.com
Format: Taschenbuch
It’s not often that you’ll see me write a lengthy book review. Most book reviews are fluff telling you to buy or not to buy a book, but don’t contain a lot of the “why” or “why not” to do so. But, every once in a while a book comes along that just strikes him in all the right ways, especially if its topic is in a core focus of yours. The book “Virtualizing SQL Server with VMware: Doing IT Right” by VMware Press and authored by Michael Corey, Jeff Szastak, and Michael Webster, is a book that I feel every VMware administrator (and any other vendor’s hypervisor administrator as well) should purchase and read twice, and I’ll tell you why in this review.

First and foremost, virtualizing business critical applications, in this case Microsoft SQL Server, is a challenge. The process is nowhere as easy as migrating a file server or preproduction sandbox. Processes and practices that may work well for some applications can cause serious heartburn, performance problems, and worse – instability – when virtualizing SQL Servers. VM administrators need to be aware of the differences, and this book delivers this knowledge and experience in droves.

This book is targeted at VMware administrators and not SQL Server DBAs. Many technical references are made to infrastructure components that most DBAs have had no exposure to (and arguably should not have to worry about unless they are a nerd like me). However, DBAs should still read the book to get a small taste of what it takes to architect and manage the virtualized environment underneath their data. The knowledge of these layers is guaranteed to make them better DBAs, and will help both organizational silos speak the same language during architecture and triage situations.

The author’s collective experience in managing these systems is quite apparent as you progress through the book. Many how-to’s and gotchya’s are described in detail. All are scenarios that I encounter frequently during my normal day in consulting around this topic. The advice presented is well thought out and shows the depth of the authors’ experience in the field.

The best part of the book is that the authors spend a great deal of time educating VMware administrators on what SQL Server is and how it uses the infrastructure underneath it as it stores and retrieves data to fulfill its requests. The authors’ style is very casual and informative, and makes each concept and topic very easy to understand and digest. For example, DBAs understand SQL Server high availability and disaster recovery. So do VM administrators. But, the two strategies are usually very different, and one group does not know the capabilities of the other technologies and how they contrast or complement each other. When you put them together, what works for one might not work for the other, and the arguments generally ensue. The authors educate the VMware administrator on how SQL Server handles high availability and disaster recovery, and suggests VMware-based processes and practices that complement and improve what SQL Server handles well, all while leveraging the right technology for each layer of the stack.

I feel that the real “meat” of the book comes in two sections – chapters five to nine and ten to eleven. The first group describes each layer of the virtualized infrastructure and breaks down architectural, performance, and configuration tips on why (and not just how) specific recommendations and architectural decisions are usually best for SQL Server on VMware.

The last two chapters do a fantastic job describing the end-to-end baselining and benchmarking process that are so frequently absent in most environments, both physical and virtual. This process helps eliminate the “it’s slow” mentality that comes from subjectivity, and replaces it with a series of objective processes for putting performance metrics to each of these layers. These metrics are key for both helping to identify the root layer of performance issues if they arise, and also eliminates the finger pointing that accompanies the “it’s your fault until you can prove otherwise” attitudes that are found in any organization.

No tech book is without its flaws, and a handful of items caught my attention while reading and re-reading this book.

The authors make a claim that CPU and memory hot-add should be enabled. I personally feel that it’s not quite as black-and-white as this. Hot-add of resources in a guest is a great feature, but hot-add also disabled virtual NUMA presentation to the VM. Correctly-sized virtual NUMA and SQL Server can improve performance, and hot-add of resources expressly disables virtual NUMA. I’ve implemented both, based on need, and I would like to see a broader discussion on the pros and cons of this setting.

Next comes the recommendation for one dedicated physical CPU core for each virtual CPU core. In my experience, it’s a great place to start, but it’s almost always too conservative and ends up “wasting” CPU time that you pay for in the form of SQL Server core-based licensing. I’d like to see this conversation include a discussion of using CPU Ready and Co-Stop times as a more objective metric for CPU overcommitment.

The jump straight into the discussion around hyper-converged architectures, in this case Nutanix, felt abrupt. Preceding this chapter should have been a short chapter comparing and contrasting the differences between rack servers, blade servers, and hyper-converged architectures. A solid discussion of how SQL Server is architected differently on each of these platforms, and the implications on performance, availability, and scalability would be a welcomed segue into the discussion on the emerging field of hyper-converged environments.

As with any first edition book, a handful of technical inaccuracies and academic practices are present, but I feel that none detract from the true mission of the book – to educate VMware administrators on virtualizing SQL Server. Items such as references for a SQL Server data file per vCPU core or data file placement sound good in theory but in practice can be tough to manage as an environment scales. I feel confident that the authors will correct the items that have been pointed out by myself and others in the next version of the book.

Some of the new features included in the recent launch of vSphere 6.0, well after the release of this book, changes some of the recommendations made in the book. I know that this release will contribute to some changes in the next version of the book as well.

To summarize, I recommend this book without hesitation to any VMware administrator who has, or needs to, virtualized business critical applications – and not just SQL Server. I give it 4.5 out of 5 stars, and look forward to seeing more from these authors in the future!
Waren diese Rezensionen hilfreich? Wir wollen von Ihnen hören.
click to open popover