SQL Server Consolidate SQL Servers:

Consolidate SQL Servers

SQL Server was created as a powerful database management system (DBMS) that is easy to use, easy to deploy, self maintaining, self tuning and cheaper than the competition. Wonderful attributes for a DBMS to have? Yes, until your company finds itself with way more SQL Servers than an already-overworked DBA can handle. To get control of SQL Server sprawl, you must consider consolidation. This e-book, by SQL Server MVP and author Hilary Cotter, will introduce you to the worlds of server and storage consolidation, offering advice to help you ease into the process and work your way toward an efficient consolidated SQL Server environment.

New in this guide

  • Chapter 1: The case for consolidation

    In Chapter 1 of this e-book, SQL Server MVP Hilary Cotter details problems associated with SQL Server sprawl, defines storage and server consolidation, and helps you decide if consolidation is right for your organization. Here you can preview two chapter excerpts -- an explanation of sprawl pitfalls and a checklist of key questions to ask before undertaking a consolidation effort -- or simply download the complete chapter.

    Learn more: Chapter 1: The case for consolidation

  • Chapter 2: Planning your consolidation

    Learn how to map out your SQL Server consolidation. SQL Server MVP Hilary Cotter organizes the process into six steps: creating a methodology, analyzing candidate servers and databases, testing, deploying, monitoring and stabilizing, and finally repeating the process for the next phase of consolidation. He also identifies key considerations for consolidating on 32-bit vs. 64-bit platforms and on single vs. multiple-instances of SQL Server.

    Learn more: Chapter 2: Planning your consolidation