Course 3591: Designing a Database Server Consolidation Strategy for Microsoft SQL Server 2005

Introduction In this online learning course you will design the database server infrastructure of an organization. You will consider the benefits and risks of consolidating database servers, and how to use multiple SQL Server instances to optimize the design of your database server infrastructure. This course also includes access to five searchable E-Reference books for quick just-in-time problem solving. This course will also help prepare you for certification exam 70-443. Objectives At the end of the course, students will be able to:

• Design a Strategy for Database Server Consolidation
• Database Server Consolidation Overview
• Design a Strategy for SQL Server Instances
• Design a Database Server Consolidation Plan

Modules & Lessons Course Overview Module Introduction Navigation Overview Designing a Strategy for Database Server Consolidation Module Introduction Overview of Database Server Consolidation Lesson Introduction The Benefits of Database Server Consolidation The Risks of Database Server Consolidation Ways to Consolidate Database Servers Database Server Consolidation Self Test Designing a Strategy for SQL Server Instances Lesson Introduction Requirements for Installing Multiple Instances How Multiple Instances Use Memory Guidelines for Designing Multiple Instances Designing a Strategy for Installing SQL Server Instances Self Test Designing a Database Server Consolidation Plan Lesson Introduction The Process of Designing a Database Server Consolidation Plan Identifying Potential Consolidation Problems Guidelines for Creating a Database Server Consolidation Plan Self Test Lab: Designing a Database Server Consolidation Strategy Lesson Introduction Scenario Exercise: Designing a Consolidation Strategy Lab Review Module Summary Glossary Module Introduction System Requirements To view this course, you need:

• A Pentium II, 256 MB RAM with a processor speed greater than or equal to 400 MHZ
• Microsoft® Windows® 2000 or higher
• Microsoft Internet Explorer 6.0 or higher
• Adobe Flash 7.0 or higher (1MB disk space needed to install)
• Microsoft Silverlight 4.0 or higher
• Microsoft Windows Media Player 7.0 or higher
• Microsoft XML Core Services 3.0 or higher
• A Super VGA monitor with minimum screen resolution 1024x768, with 16-bit color.
• A sound card, and either speakers or headphones (for multi-media audio).
• Internet bandwidth of 56K or faster. Broadband internet access is recommended.

For courses containing Virtual Server-based labs (courses in the IT Professional and Developer Catalog), you will need:

• Microsoft Virtual Server ActiveX control (1MB disk space needed to install)

Test your computer's capabilities to see if it supports this course. Accessibility Requirements The following software must be running on your computer in order to access this course with Screen Reader Software:

• Microsoft Internet Explorer 6.0 or higher
• Window-Eyes from GW Micro
• JAWS from Freedom Scientific
• MSAA enabled