Step-by-Step Guide: How to consolidate SQL Servers

This information is excerpted from Chapter 2, 'Planning your SQL Server consolidation,' of our original expert e-book, "Consolidate SQL Servers for availability, scalability and cost savings." This chapter explains five steps to consolidation and other key consolidation considerations.

How to consolidate SQL Servers

 Home: Introduction
 Step 1: Create a SQL Server consolidation methodology
 Step 2: Analyze candidate databases, servers and more
 Step 3: Test your consolidation
 Step 4: Deploy consolidated SQL Servers
 Step 5: Monitor and stabilize consolidated SQL Servers

ABOUT THE AUTHOR:

Hilary Cotter Hilary Cotter has been involved in IT for more than 20 years a Web and database consultant. Microsoft first awarded Cotter the Microsoft SQL Server MVP award in 2001. Cotter received his bachelor applied science degree in mechanical engineering from the University of Toronto and studied economics at the University of Calgary and computer science at UC Berkeley. He is the author of a book on SQL Server transactional replication and currently working on books on merge replication and Microsoft search technologies. Copyright 2006 TechTarget

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT SQL Server High Availability, Scalability and Reliability SQL Server high availability: Options and caveats High availability and the database Are data warehouses made for the cloud? Top load balancing methods for SQL Server Maintaining high availability of SQL Server virtual machines Creating fault-tolerant SQL Server installations Scaling up vs. scaling out with SQL Server 2008 How to configure storage in SQL Server database with more writes than reads SQL Server database replication tutorial Licensing a standby server for SQL Server replication SQL Server High Availability, Scalability and Reliability Research Chapter 2: Planning your consolidation Chapter 2: Planning your SQL Server consolidation Weed out poor candidates for database consolidation

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary