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

  • The 2020 Microsoft Product Roadmap

    From the next major update to Windows 10 to the next generations of .NET and PowerShell, here's what's on tap from Microsoft this year.

  • Microsoft's Power Platform, Dynamics 365 Get AI Boost with Orions Systems Buy

    Microsoft this week acquired Orions Systems with plans to bring the firm's AI-powered video analysis solutions to the Dynamics 365 and Power Platform products.

  • 2020 Microsoft Conference Calendar: For Partners, IT Pros and Developers

    Here's your guide to all the IT training sessions, partner meet-ups and annual Microsoft conferences you won't want to miss. (Now updated with COVID-19-related event changes.)

  • Microsoft Partners with Movial To Bring Android to Surface

    Microsoft is adding more Android expertise to its in-house engineering teams via a deal with Movial, a software engineering and design services company based in Finland.

RCP Update

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.