These are excerpts from the Microsoft whitepaper “SQL Server 2008 Performance and Scale” published here (MyTestBox.com got the permisison from Microsoft to reprint it here).
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 the latest hardware technologies while scaling up your servers to support server consolidation. SQL Server 2008 also enables you to scale out your largest data solutions.
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 many products, 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 database with 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 data continues 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 a robust 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 with the 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 3-terabyte and 10-terabyte categories. (For current benchmark results, see the TPC Web site at www.tpc.org.)