Introduction to SQL Server 2008 Server consolidation features

Source: Internet
Author: User
Tags management studio sql server management sql server management studio

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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.