sql server 2008 server consolidation

Your Data Any Place, Any Time

Server Consolidation

Reducing the Cost of Running Servers

ForwardConsolidation

BackwardConsolidation

Rationale for Consolidation

Improve Management

Inte

rope

rabi

lity

Reduce Servers

Flexibility

Manageability

Scalability and

Performance

SQL Server 2008Server Consolidation

Flexibility

Manageability

Scalability and

Performance

Consolidation

Options

Migration Technologie

s

Flexibility

Flexibility

Consolidation OptionsSingle instance, multiple databases

Reduces physical servers Centralizes database server

administration Supports workload isolation

through Resource Governor

Consolidation OptionsSingle server, multiple instances

Reduces physical servers Centralizes server administration Supports isolation of:

Workload Security Database server administration Compatibility

Requires a single license per processor

Consolidation OptionsSingle physical server, multiple virtual servers

Reduces physical servers Centralizes server hardware

administration Supports full server isolation Requires a single license per

processor For SQL Server 2008 Enterprise

Edition

SQL Server 2008 data transfer technologies SQL Server Integration Services Detach and attach Backup and restore

Migration Technologies

Upgrade directly from previous versions

Flexibility

Manageability

Scalability and

Performance

Manageability

Administration Aud

itingConfiguration

Monitoring

Manageability

AdministrationSQL Server Management Studio

Centralized management of multiple:

Services Instances Editions Versions

Auditing

Centralize enterprise wide audit reporting

Define audit filters on one instance, and apply to many instances

ConfigurationDeclarative Management Framework

Enforce policies: Proactively through triggers After changes through Service Broker On a scheduled basis through SQL Server Agent On an ad-hoc basis

Define policies on one instance, and apply to many instances

MonitoringPerformance Studio

• Data Collection

• Performance and

Diagnostics Monitoring

• Historical and baseline

comparisons

• Troubleshooting and Tuning

Data Collection

Sets

Dashboard (post Katmai)

Management Data

Warehouse

Policy based management

Flexibility

Manageability

Scalability and

Performance

Manageability

Resource

utilizationScaling upScalability

and Performance

Resource UtilizationResource Governor

Differentiate workloads Based on application, user, etc.

Define resource utilization limits CPU Memory

Covered Scenarios: Preventing runaway queries Predictable concurrent execution of

different-size workloads Workload prioritization

Scaling Up

64-bit scalability Take advantage of 64-bit hardware

Hot-add memory and CPU Add hardware without downtime

Native data compression Reduce storage requirements Increase performance for high I/O workloads

Flexibility

Manageability

Scalability and

Performance

Summary

© 2004 Microsoft Corporation. All rights reserved.This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.