addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgooglegroupshelp-with-circleimageimagesinstagramlinklocation-pinm-swarmSearchmailmessagesminusmoremuplabelShape 3 + Rectangle 1ShapeoutlookpersonJoin Group on CardStartprice-ribbonShapeShapeShapeShapeImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruserwarningyahoo

SQL Server Consolidation Strategies

  • Sep 12, 2012 · 6:30 PM
  • Microsoft Office

Speaker: Rick Heiges, SQL Server MVP

There are many approaches to SQL Server Consolidation. Each organization has unique business rules that impact the decision on which approach fits their needs. This session will cover the various approaches from Instance Stacking / Virtualization to Appliances and where they "fit". You'll hear about methods for data collection from Perfmon to Powershell and the Microsoft MAP Toolkit. Lastly, Rick will discuss strategies to uncover the business rules, as these will be the true limiting factors of how far a consolidation effort can go.

He'll also take a look at Microsoft's latest Fast Track architecture for a Private Cloud and how that may play into your strategy.

You'll learn:

  • The various features of SQL Server that enable consolidation
  • Different approaches for consolidating SQL Server
  • How to start building a framework for your organization
  • How licensing may impact your framework
  • How virtualization may fit into your consolidation strategy

Rick Heiges is a SQL Server MVP and a Solutions Architect with Scalability Experts. He works with customers on solutions within the SQL Server environment and speaks at user groups, conferences, labs, and road shows across the USA, Europe, and Africa. Rick holds an MBA and a M.S. in MIS and a B.S. in Computer Science. He has worked as a professor, developer, trainer, database administrator, and project manager/leader. Rick served on the PASS Board of Directors from 2003 – 2011 and started the 24 Hours of PASS virtual events.

Join or login to comment.

  • Reghardt van R.

    I come from a very heavy background in SQL Server consolidation (VM, Hardware, instance stacking, SQL Server farms, clustered instance stacking, etc.) so there was not a lot of new information that I got from the presentation. It was however very nicely presented and put together, and I would definitely recommend this presentation for someone who is new to database consolidation.

    September 13, 2012

  • A former member
    A former member

    My feedback is relative. Since my level of understanding when it comes to systems management and Sql Server management is lower than most in that audience, SOME of the material was over my head in terms of the specifics but understandable in broader strokes.

    September 13, 2012

  • key88

    Good info, interesting tips on running sql as vm guests. Glad to see more people doing that.

    September 12, 2012

46 went

Our Sponsors

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy