Introduction to SQL Server 2008 Server consolidation features

SQL Server 2008 provides a flexible server consolidation solution with enterprise-class management capabilities and performance, reducing the cost of hardware and maintenance.

Flexible, manageable, and scalable data Services consolidation

Flexibility

Choose the Data Services consolidation solution that best suits your business

· Merging servers with multiple databases and instances

Use SQL Server 2008 to store multiple databases in a separate server instance for centralized data storage and management. Running multiple instances of SQL Server 2008 on a separate server to maintain the independence of database applications, while also reducing hardware costs, licensing costs, and administrative costs.

· Merging Data services through virtualization

Use Microsoft Virtual Server to run multiple virtual operating systems on the same physical computer with one or more instances of the required SQL Server 2008 service on each virtual machine.

· Easy Transfer and migration of databases and data

Choose the right data transfer method to incorporate data that incorporates extensive technology in SQL Server 2008, including backup and recovery, connectivity and separation, and SQL Server Consolidation services (SQL Server integration Service).

Management capacity

Effectively manage, monitor, protect, and optimize merged data systems.

· Using SQL Server Management Studio Centralized Management

Manage multiple instances on a separate server and multiple SQL Server instances on a different virtual machine using a separate, compatible management interface, and manage each version of SQL Server 2000, SQL Server 2005, and SQL Server 2008.

· Centralized review

Configure server and database-level review settings on a single server instance, and then deploy them to other instances. Consolidated enterprise-wide audit records from multiple sources, such as SQL Server Analysis Services (SQL Server Analytics Service) and report Services (Reporting service).

· Performing configuration policy compliance checks in the enterprise

Define configuration policies using the declarative Management Framework and apply them to servers, databases, tables, and other objects, so merge configuration management is done by defining a policy and reusing it on servers throughout the enterprise.