TPC-C And Database Performance Optimization

With the rapid development of computer science and digital information, almost every corporation creates their owner information system. As the core and basic component of these information systems, database is used more and more in these systems. So many attentions are paid to the database performance, and there are series of benchmarks for testing the database performance. As an authoritative benchmark, TPC-C is accepted by most of the database vendors in the world. Because of its regular metric, commercial test environment and objective result, TPC-C is becoming more and more popular in its field.As a benchmark test for OLTP, TPC-C simulates a complex commercial environment in which a lot of terminal users operate on the database to execute frequent and disordered transactions. A New-Order transaction is the core transaction in the benchmark, and there are four assistant transactions: Payment, Order-Status, Delivery and Stock-Level.Under the background of SQL Server Migration project for State Street Bank, this paper introduces the basic of database first, then analyses the mode of TPC-C benchmark. After initializing the tables and data for the TPC-C testing, I get the statistical data for performance gap between the SQL Server 7.0 and SQL Server 2000 database server.The last part of this paper is focusing on the database performance optimization, and proposes a series of methods to improve the database performance. I take the SQL Server database as an example, apply a top to down methodology, and propose some optimization suggestions from the application layer, database layer, and operating system layer and hardware layer aspects. I do lots of practices and analyze especially on database server, SQL sentence and stored procedure during my work, and I hope that it will take effect in the future work.