server| performance wondering where is SQL Server 7.0 stronger than SQL Server 6.5 or other enterprise-level database systems? Please read SQL
Server 7.0 's industrial standard benchmark score and record performance metrics. </p>
<p>
I. Industrial standards
The ideal method for evaluating hardware and software is to compare the different systems of organizations, to detect their performance under certain workloads, to assess development potential and to estimate costs. Of course, no organization has enough time and resources to carry out all the tests, so they use well-designed, highly trusted industrial standard benchmark (Benchmark) tests.
Microsoft, in close collaboration with leading independent software vendors (isv,independent Software Vendor) and original equipment manufacturers, has released SQL
Server 7.0 Industrial Standard benchmark test. These include benchmark testing from a number of independent software vendors, such as Baan, PeopleSoft, SAP, and transaction Processing performance Committees (tpc,transaction
Processing performance COUNCIL) benchmark as well as backup and recovery benchmark.
SQL Server has a series of stunning records on the Microsoft Windows Nt®server platform that delivers the industry's best performance and best price/cost. When it was released in November 1998, SQL
Server 7.0 creates new records for Baan, PeopleSoft, tpc-c single node performance, and backup and recovery benchmark tests on the Windows NT server platform.
</p>
<p>
Two. Independent software vendors (isv,independent Software vendor) Benchmark
Hundreds of independent software vendors offer customized, SQL Server 7.0-based applications. Therefore, the ISV
Benchmark is a good way to compare database performance by providing independent information under simulated workloads.
The benchmark of Baan and PeopleSoft
SQL Server 7.0 achieves record performance for 3,537 Baan reference users (Bru,baan Reference user) over previous Oracle
Creates the highest record of the benchmark on the Windows NT platform. This result was in a configuration of four-way Pentium
II Xeon, the Compaq of the MHz processor is implemented on the ProLiant 7000 server.
SQL Server 7.0 also creates the best performance on the Windows NT platform in the two benchmark of PeopleSoft. In Hrms
In the Online 7.5 test, it achieved a result of 5700 users, almost four times times the original highest record created by SQL Server 6.5. In FS
On the Online 7.0 test (PeopleSoft another benchmark), SQL Server 7.0 has a record of 2500 users on the Windows NT platform. These results are in a configuration of four-way Pentium
II Xeon, the Compaq of the MHz processor is implemented on the ProLiant 7000 server.
SQL Server 7.0 from Baan, PeopleSoft, and SAP Beta 3 Benchmar (July 1998) http://www.microsoft.com/presspass/press/1998/Jun98/ Sqlbt3pr.htm
In the first benchmark test with Baan IV, SQL Server 7.0 Beta 3 created Windows
The optimal performance of the NT server platform results in 3,232 Baan reference users.
SQL Server 7.0 Beta 3 run PeopleSoft Payroll version 7.0 can process 41,328 checks per hour and also creates Windows
The best performance record for the NT server platform. These stunning results are in a configuration of four-way Pentium
II Xeon (1 m two cache) processors are implemented on COMPAQ ProLiant 7000 servers.
SQL Server 7.0 Beta 3 SAP Benchmark (September 1998)
http://www.unisys.com/AboutUnisys/PressReleases/1998/sep/09146550
Microsoft SQL Server 7.0 Beta 3 implements 2,400 sales and distribution for SAP R/3 systems (sd,sales
and distribution) The results of the user. This result is 137% higher than the highest SQL Server 6.5 record, in one configuration four-way Pentium
II Xeon processors are implemented on Unisys QS/2 servers. </p>
<p>
Three. TPC Benchmark
The transaction Processing Performance Board (TPC, Transaction processing performance Council) is a non-profit company that defines transaction processing and database benchmark. The current membership includes all major database vendors and server hardware vendors. The company defines a series of benchmark, called Tpc-a, Tpc-b, tpc-c™ and tpc-d, respectively.
TPC-C is the industrial standard for measuring online analytical processing (oltp,online Transaction processing) systems. It tests a wide range of database capabilities, including query, update, and queued Mini-batch (pocket-sized batch) transactions. This specification is very stringent in key areas, such as database transparency and transactional isolation. Many IT experts put tpc-c as a good indicator of the performance of the "real world" OLTP system. Independent auditor Certification Benchmark results, TPC also has a full set of public reports. These reports are excellent sources of information about system performance and system costs. You can read these public reports http://www.tpc.org/on TPC's Web site.
SQL Server 7.0 creates a tpc-c cost-performance record
According to the results of the Compaq announcement, SQL Server 7.0 implemented 22,478 transactions/min at the $18.84/TPMC price
(tpmc,transactions per minute), this is the first time the database manufacturers to reduce the cost to $20/TPMC below. This benchmark also represents the minimum system cost for all comparable quad-processor systems. These results are in a single running Microsoft
SQL Server 7.0 Enterprise Edition and Windows NT Server 4.0 Enterprise Edition, configure quad 450MHz Pentium II
Xeon processor on the ProLiant 7000 server is obtained.
In addition, SQL Server 7.0 continues to remain in the top 16 of the TPC-C cost-performance category. </p>
<p>
Four. Backup benchmark
Backup and recovery is a critical area of any database. Backup and restore large SQL Server
The 7.0 database can be completed with the high throughput required by mission-critical applications and minimizes disruption to production work.
SQL Server 7.0 backup and recovery performance on Windows NT platform (November 1998) http://www.compaq.com/solutions/enterprise/database-mssqlserver-execsumm.html
With SQL Server 7.0 Enterprise Edition, Microsoft and Compaq have achieved the fastest online backup and recovery performance on the Windows NT platform, with average throughput up to online backup 609gb/hours and online recovery 536gb/hours. This benchmark test also shows that backup operations have less impact on transaction throughput, thus greatly reducing the system requirements for backup operations. These results are in a configuration of the eight processor Compaq
AlphaServer 8400 Server and 32 AIT tape drives are available.
For more information on SQL Server performance, read the Benchmark: High-performance Online backup Mega database white paper http://www.microsoft.com/china/sql/70/whpprs/highperf.htm
SQL Server 7.0 Beta 3 Demo Low-price backup solution (August 1998)
Http://www.hp.com/pressrel/aug98/10aug98f.htm
Working in close collaboration with Microsoft and Adaptec, Hewlett-Packard demonstrated superior active database backup, with throughput exceeding 100gb/hours, while 250 of users continued online transaction processing. In Hewlett-Packard
The NetServer transaction workload runs on the system, and the SQL Server 7.0 Backup utility maintains a normal 88% online throughput while performing backup operations. In addition, the company demonstrated that the backup free database reached the level of 195GB per hour.
For more information on this test, read the Benchmark: Keeping the transaction high throughput while you are backing up the database online white paper
<a href= "http://www.microsoft.com/china/sql/70/whpprs/hpbenchmark.htm" >http://www.microsoft.com/china/sql /70/whpprs/hpbenchmark.htm</a>
</p>
<p>
Five. Performance adjustment
Performance can be measured by the amount of I/O, CPU time, and reaction time required to process the transaction. As a result, performance tuning is improved for SQL
Server performance is critical.
The goal of performance tuning is to maximize the processing throughput of all users by reducing network traffic, reducing disk I/O, and reducing CPU time to provide the response time that each query can accept. Achieving this requires an in-depth analysis of application requirements and an understanding of the logical and physical structure of the data, as well as the ability to judge and balance database usage conflicts.
Microsoft SQL Server 7.0 Performance Tuning Guide
http://www.microsoft.com/china/sql/
