News

World's Biggest Production Databases Now Include Windows

Windows servers and SQL Server 2000 now power some of the world's biggest production databases, according to an annual survey from data management analysts at Winter Corp.

Waltham, Mass.-based Winter Corp. recently released results of its Winter TopTen Program, which is done annually based on customer surveys and a script run on the databases to verify the facts submitted in the survey.

For the first time, Microsoft products made their way onto some of Winter's "All Environments" TopTen lists, which include Unix and mainframe systems. A massive SQL Server 2000 production database run by Verizon Communications placed sixth for overall OLTP database size and third for largest number of rows in an OLTP database. The Verizon database is 5.3 terabytes and has more than 33 billion rows of data.

"We think it's a great win because a lot of times customers or partners don't think about SQL Server being this enterprise, mission-critical database," says Tom Rizzo, director of product marketing for SQL Server. "It's great that it's a third-party validation. We've always been saying, 'Hey, SQL Server can scale.' A lot of people looked at that and said, 'Hey, that's Microsoft saying that.'"

Meanwhile, an Oracle database running on a Windows server at HP also made the OLTP TopTen, sliding in at No. 8 at 3.2 terabytes in size.

According to Winter Corp., the largest OLTP production database is an IBM DB2 cluster system run by Land Registry. That mainframe-based system is 18.3 terabytes.

Two other SQL Server-based databases made the TopTen list for most rows in an OLTP database across all environments. A 17-billion-row database at Commander Communication ranked fourth, and another database at Verizon with nine billion rows ranked ninth.

Microsoft products were not yet competitive in Winter's other database category -- decision support systems. The TopTen consisted entirely of Unix-based systems ranging from a 29.2-terabyte Oracle database to a 9.1-terabyte NCR Teradata database. The largest Windows-based DSS database found in the survey was an 8.9-terabyte Sybase IQ system at ComScore Networks Inc. Sybase IQ systems at ComScore accounted for the top three Windows-based DSS systems. The fourth- and fifth-largest Windows-based DSS systems were Oracle databases at HP.

The largest Microsoft SQL Server-based DSS system was sixth on the list of the TopTen Windows-based DSS systems -- a 1.6-terabyte system at Arclight Systems, LLC.

To be considered in its annual survey Winter Corp. requires Windows-based databases to be at least 500 GB in size. Some 25 SQL Server implementations were entered in the 2003 run with databases that big or larger. Of those, 15 of the databases were 1 terabyte or larger and four were 2 terabytes or larger.

Results of the Winter Corp. survey are available here.

About the Author

Scott Bekker is editor in chief of Redmond Channel Partner magazine.

Featured

  • Report: Cost, Sustainability Drive DaaS Adoption Beyond Remote Work

    Gartner's 2025 Magic Quadrant for Desktop as a Service reveals that while secure remote access remains a key driver of DaaS adoption, a growing number of deployments now focus on broader efficiency goals.

  • Windows 365 Reserve, Microsoft's Cloud PC Rental Service, Hits Preview

    Microsoft has launched a limited public preview of its new "Windows 365 Reserve" service, which lets organizations rent cloud PC instances in the event their Windows devices are stolen, lost or damaged.

  • Hands-On AI Skills Now Outshine Certs in Salary Stakes

    For AI-related roles, employers are prioritizing verifiable, hands-on abilities over framed certificates -- and they're paying a premium for it.

  • Roadblocks in Enterprise AI: Data and Skills Shortfalls Could Cost Millions

    Businesses risk losing up to $87 million a year if they fail to catch up with AI innovation, according to the Couchbase FY 2026 CIO AI Survey released this month.