Microsoft SQL Server Consolidation and Virtualization: Myths and Realities
Server consolidation has been pursued for years yet not many companies have been truly successful when it comes to database consolidation. The maturation of virtualization technologies further adds to the many considerations users have to deal with in a consolidation project. Each vendor you talk to claims they have the best solution and/or technology for SQL Server consolidation while others are just selling snake oil. Who's right? What exactly is the relationship between consolidation and virtualization? Are they one and the same? If so, then why are there so many different technologies, each employing different strategies? Should I get the biggest server or build a server farm? Is automated server/instance provisioning truly automated? When do I even start thinking about consolidation and/or virtualization? These are some of the questions that are answered in this session, along with key best practices and caveats learned from dozens of consolidation projects that range from a dozen to over 4,000 SQL Server databases. This session explores key considerations in a consolidation project and common oversights that derail the project. It also reviews notes from the field on the various solutions available today, the strengths, weaknesses and what scenarios they are most appropriate for. This session is about what happens after the cool demos and flashy presentations are over and users wake up to the good, bad, and ugly realities of consolidation and virtualization.