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
- Testing your SQL Server consolidation environment (Chapter 2: Planning your consolidation)
- Weed out poor candidates for database consolidation (Chapter 2: Planning your consolidation)
- Step-by-Step Guide: How to consolidate SQL Servers (Chapter 2: Planning your consolidation)
-
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.
-
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.