SQL Server Customers Get Worldwide Recognition for Enterprise-Class Scalability
|
Microsoft would like to congratulate the following SQL Server 2000 customers for managing the world's largest and most powerful databases as recognized by the 2003 Winter Corporation TopTen survey. The recognition of several 1-terabyte and larger databases demonstrates the enterprise-class scalability of SQL Server. SQL Server databases also lead Winter Corporation's Workload TopTen lists.
Survey Results for the Largest SQL Server Databases
Source: Winter Corporation, Waltham, MA, USA
View the complete survey results.
According to the survey results, SQL Server runs:
| • | The world's largest database for transaction processing on the Microsoft Windows platform, with 5.3 terabytes of data. |
| • | The world's third largest transaction processing database by row count for All Environments, with 33 billion rows. |
| • | The world's sixth largest transaction processing database for All Environments. |
Additional honors for SQL Server include:
| • | 7 of the world's top 10 largest databases for transaction processing on Windows. |
| • | 9 of the world's top 10 largest databases by row count for transaction processing on Windows. |
| • | 4 of the world's top 10 largest transaction processing databases by rows, across All Environments. |
| Company | Category | Database Size in Windows Environments | Number of Rows in Windows Environments | ||
| Size1 (GB) | Rank2 | Rows (Millions) | Rank3 | ||
Verizon Communications | OLTP | 5,319 | 14 | 33,341 | 15 |
Lucent Technologies | OLTP | 2,885 | 3 | 192 | 16 |
Commander Communication | OLTP | 2,876 | 4 | 17,033 | 26 |
Verizon Communications | OLTP | 2,243 | 5 | 9,157 | 37 |
Verizon Communications | OLTP | 1,790 | 6 | 6,605 | 5 |
Internet Auction Co., Ltd. | OLTP | 1,708 | 8 | ||
Arclight Systems, LLC | DSS | 1,640 | 6 | 6,246 | 5 |
Verizon Data Services | OLTP | 1,452 | 10 | 7,130 | 4 |
Scottish and Southern Energy | OLTP | 1,378 | 11 | 5,828 | 7 |
Anonymous | OLTP | 1,303 | 12 | ||
Verizon Communications | OLTP | 1,300 | 13 | 5,922 | 6 |
DataQuick | DSS | 1,262 | 7 | 3,273 | 9 |
Verizon Communications | OLTP | 1,216 | 14 | 5,273 | 8 |
Edgars Consolidated Stores | DSS | 1,005 | 9 | 5,543 | 6 |
Fair Isaac (NAREX, Inc.) | DSS | 1,001 | 10 | 3,228 | 10 |
Verizon Communications | OLTP | 999 | 15 | 4,266 | 9 |
First Premier Bankcard | DSS | 926 | 11 | 1,773 | 14 |
Gomez | DSS | 781 | 12 | 3,418 | 8 |
Stratapult Inc. | DSS | 706 | 13 | 2,214 | 13 |
2001OUTLET Co. Ltd | OLTP | 626 | 16 | 1,254 | 12 |
Anonymous | DSS | 552 | 15 | 1,256 | 15 |
Ordina | DSS | 547 | 16 | 6,402 | 4 |
Anonymous | OLTP | 523 | 19 | 1,306 | 11 |
Clalit | DSS | 512 | 17 | 2,705 | 12 |
| 1 | Single instance database |
| 2 | OLTP and DSS databases are ranked separately. Reflects worldwide rank out of all database providers. |
| 3 | OLTP and DSS databases are ranked separately. Reflects worldwide rank out of all database providers. |
| 4 | Ranks #6 in all environments |
| 5 | Ranks #3 in all environments |
| 6 | Ranks #4 in all environments |
| 7 | Ranks #9 in all environments |
Survey Results for the Largest Workload SQL Server Databases
Source: Winter Corporation, Waltham, MA, USA
View the complete survey results.
According to the survey results, SQL Server runs:
| • | The world's second largest workload for transaction processing for All Environments (second only to a legacy CA-IDMS mainframe system, and ahead of all Oracle and IBM entries). |
| • | The world's largest workload for both transaction processing and decision support on Windows, with 4,010 transactions per second (TPS) and 167 concurrent in-flight queries respectively. |
| • | The world's ninth largest workload for decision support for All Environments—a first appearance for Microsoft on this Winter Corporation TopTen list. |
Additional honors for SQL Server include:
| • | All of the world's largest workloads on Windows (OLTP and DSS) run SQL Server. |
| • | 6 of the world's top 10 largest workloads for transaction processing on All Environments (second through seventh). |
| Company | Category | Workload in Windows Environments1 | Rank2 |
Anonymous | OLTP | 4,010 | 13 |
Internet Auction Co., Ltd. | OLTP | 3,634 | 24 |
Commander Communications Ltd. | OLTP | 2,604 | 35 |
Scottish and Southern Energy plc | OLTP | 2,152 | 46 |
2001OUTLET Co. Ltd. | OLTP | 1,204 | 57 |
Anonymous | OLTP | 1,200 | 68 |
Verizon Communications | OLTP | 206 | 7 |
Stratapult Inc. | DSS | 167 | 89 |
Verizon Communications | OLTP | 131 | 9 |
Verizon Communications | OLTP | 128 | 10 |
Verizon Communications | OLTP | 113 | 11 |
Arclight Systems, LLC | DSS | 32 | 12 |
DataQuick | DSS | 25 | 13 |
NAREX, Inc. | DSS | 10 | 14 |
| 1 | OLTP peak workloads are measured in database transactions per second and DSS peak workloads are measured in concurrent in-flight queries. |
| 2 | OLTP and DSS databases are ranked separately. Reflects worldwide rank out of all database providers. |
| 3 | Ranks #2 in all environments |
| 4 | Ranks #3 in all environments |
| 5 | Ranks #4 in all environments |
| 6 | Ranks #5 in all environments |
| 7 | Ranks #6 in all environments |
| 8 | Ranks #7 in all environments |
| 9 | Ranks #9 in all environments |
Do You Have a Large Database?
Send an e-mail to the SQL Server Scalability Team and let us know about your large database. You can also enter the next Winter Corporation TopTen survey, launching in January 2004. For more information, visit the Winter Corporation site.
About Winter Corporation
Winter Corporation is an independent consulting firm that focuses on database scalability and enterprise data management. The Winter TopTen Program is a survey that identifies the world's largest and most powerful databases and the products and vendors who support them. The program identifies the top ten online transaction processing (OLTP) and decision support system (DSS) databases in database size, row size, and workload for Windows, Unix, and all environments.
Survey Requirements
| • | Minimum database size for Windows platform is 500 gigabytes (GB). |
| • | Data size includes all data excluding free space and redundancy. |
| • | OLAP data is not included. |
For More Information
| • | eWeek Article Discusses Survey Results |
| • | Advantages of 64-bit to SQL Server 2000 Enterprise Edition Business Intelligence Customers |
| • | How SQL Server performed in TopTen 2005 |