Published: February 2008
Updated: July 2008
Summary: Microsoft SQL Server 2008 incorporates the tools and technologies that are necessary to implement relational databases, reporting systems, and data warehouses of enterprise scale, and provides optimal performance and responsiveness. With SQL Server 2008, you can take advantage of thelatest hardware technologies while scaling up your servers to support server consolidation. SQL Server 2008 also enables you to scale out your largest data solutions.
For the latest information, see Microsoft SQL Server 2008.
Optimizing Performance with SQL Server 2008 1
Relational Database Performance 1
Measurable, Real-World Performance 1
High PerformanceQuery Processing Engine 2
Performance Optimization Tools 2
Resource Governor 3
Performance Studio 3
Data Warehousing and Analysis Performance 5
Reporting Services Performance 6
Integration Services Performance 6
Scaling Up with SQL Server 2008 7
Hardware Support 7
Advanced Concurrency Features 8
Scaling Out with SQL Server 2008 8
Scalable Shared Databases 8
Data DependentRouting 9
Peer-to-Peer Replication 9
Query Notifications 9
Scalable Shared Databases for Analysis Services 9
Today’s organizations need easily accessible and readily available business data so that they can compete in the global marketplace. In response to this need, relational and analytical databases continue to grow in size, embedded databases ship with manyproducts, and many companies consolidate servers to ease management concerns. Companies must maintain optimal performance while their data environment continues to grow in size and complexity.
This white paper describes the performance and scalability capabilities of Microsoft® SQL Server® 2008 and explains how you can use these capabilities to:
Optimize performance for any size of databasewith the tools and features that are available for the database engine, analysis services, reporting services, and integration services.
Scale up your servers to take full advantage of new hardware capabilities.
Scale out your database environment to optimize responsiveness and to move your data closer to your users.
Optimizing Performance with SQL Server 2008
Because your corporate datacontinues to grow in size and complexity, you must take steps to provide optimal data access times. SQL Server 2008 includes many features and enhancements to optimize performance across all of its areas of functionality, including relational Online Transaction Processing (OLTP) databases; Online Analytical Processing (OLAP) databases; reporting; and data extract, transform, and load (ETL) processes.Relational Database Performance
In most business environments, relational databases are at the core of business-critical applications and services. As volumes of data increase, and the number of users and applications that are dependent on relational data-stores grows, organizations must be able to ensure consistent performance and responsiveness from their data systems. SQL Server 2008 provides arobust database engine that supports large relational databases and complex query processing.
Measurable, Real-World Performance
SQL Server 2008 builds on the industry-leading performance of previous versions of SQL Server to provide the highest possible standard of database performance to your organization. Having demonstrated the high performance capabilities of SQL Server in the past withthe Transaction Processing Performance Council’s TPC-C benchmark, Microsoft was the first database vendor to publish results for the newer TCP-E benchmark, which represents more accurately the kinds of OLTP workloads that are common in modern organizations.
Additionally, SQL Server demonstrates its performance capabilities for large-scale, data warehousing workloads through TPC-H results in the...