Data Warehousing

Combine preconfigured servers, storage, and networking with SQL Server 2008 R2 Enterprise for a scalable enterprise data warehouse platform.

Accelerate time-to-value

• Choose industry-standard hardware from Dell, HP, Bull, IBM, EMC, and other leading vendors.

• Eliminate guesswork and save time by selecting hardware that is tested for data warehousing.

• Buy all your hardware, including servers, storage, and networking, from one vendor.

• Speed up creation or migration of data warehouses.

• Build dedicated symmetric multiprocessing (SMP) data warehouses for various business units on one platform.

Reduce the costs of enterprise data warehousing

• Accelerate deployment.

• Gain predictable performance.

• Benefit from different levels of performance, scalability, and price to suit business needs.

• Choose from two-processor, four-processor, or eight-processor configurations.

• Save money, knowing that implementing a comparable Oracle system costs two-thirds more.

Optimize data warehousing for better out-of-the-box performance with less effort.

Take full advantage of your database and hardware

• Balance all hardware and software components for best performance.

• Eliminate potential performance bottlenecks.

Rely on consistent performance from validated reference architectures

• Optimize for sequential input/output (I/O) rather than random I/O.

• Support up to 200 MB/s per CPU core.

• Receive guidance and best practices from Microsoft for smooth deployment and consistent performance.

• Achieve similar performance at less than one-fifth the cost of other leading vendors.

Take advantage of best practices on Windows Server configuration and SQL Server database management with solutions that are designed with a rigorous, holistic approach.

Benefit from enhancements in SQL Server 2008 R2 Enterprise

• Take advantage of data compression.

• Make use of parallel partitioning.

• Optimize star join queries.

Employ an updated best-practices methodology

• Use step-by-step technical guidance from Microsoft.

• Lay out data for improved performance.

• Enable rapid deployment, advanced tuning techniques.

• Build, tune, and deploy with confidence.

• Customize to suit your workload and performance requirements.

• Enhance performance, scalability, and manageability.

Look to the future

• Build a solid road map to large-scale enterprise data warehousing on SQL Server R2 as data grows.

• Support configurations that can become integrated SMP “spokes” in a distributed data warehouse architecture.