Built on SQL Server Enterprise, SQL Server 2008 R2 Datacenter is designed to deliver a high-performing data platform that provides the highest levels of scalability for large application workloads, virtualization and consolidation, and management for an organization's database infrastructure. Datacenter helps enable organizations to cost effectively scale their mission-critical environment.
Improve hardware utilization through maximum consolidation support
Consolidate databases onto fewer machines with maximum virtualization limits and Windows Server 2008 R2 Hyper-V support. Assess resource utilization at scale for maximum optimization with Application and Multi-instance Management. Host multiple databases on a server without compromising performance and scalability without hardware processor and memory limits. Create a library of VHDs ready to be deployed when needed with SQL Server Sysprep.
Lower costs and increase business continuity
Help reduce hardware costs, optimize storage, and improve I/O performance with data and backup compression. Achieve high availability through database mirroring and maximum server clustering support. Move virtual machines between host servers without service interruption with Windows Server 2008 R2 Hyper-V. Help enable high availability and reduce downtime with indexing and restore operations and hot-add and hot-replace CPU and memory capabilities.
Optimize high-scale database management for compliance and performance
Help improve performance through table and index partitioning, query parallelism, scalable shared database deployments, and enhanced read-ahead and scan capabilities. Define hardware resource limits for individual workloads for predictable performance across multiple database workloads with Resource Governor. Help accelerate impact analysis and identify issues before they become problems with Performance Data Collector, SQL Server Profiler, and Database Engine Tuning. Proactively define configuration policies and apply them across your SQL Server environment to ensure enterprise-wide compliance without the administrative overhead. Gain the highest data protection to meet strict compliance requirements with built-in features like SQL Server Audit, Transparent Data Encryption and Enterprise Key Management.
Enjoy built-in business intelligence for thousands usersProduct Highlights
Improve business efficiency by creating a single, consolidated data warehouse for business analytics and reporting - support up to tens of terabytes of data. Ensure you have a single standardized version of your data for operational and reporting consistency across the enterprise with Master Data Services. Perform complex data analyzes using a familiar tool, Microsoft Office Excel 2010, and share results in Microsoft Office SharePoint with the new PowerPivot Add-in. Deliver business insights with controlled access across the enterprise with a suite of self-service business intelligence features and SQL Server Reporting Services. Share reports quickly and seamlessly through Microsoft Office SharePoint integration - publish directly to a SharePoint library or embed reports directly into SharePoint portal web parts.
- Gain insights and manage hundreds of instances per Control Point with Application and Multi-Server Management
- Leverage highest virtualization support for maximum ROI on consolidation and virtualization
- Enable high-scale complex event processing with StreamInsight
- Enjoy the highest levels of scale through support for more than 8 processors and up to 256 logical processors
- Use powerful hardware with maximum OS memory enablement