SQL Server and Scalability

Is SQL Server 2005 truly scalable? Can it really run big databases?

Well, I’m convinced. The enterprise edition can, within the constraints of the operating system, run databases of unlimited size than use unlimited RAM on any number of CPUs. It supports 64-bit operation, partitioning and parallel index operations.

Still smarting under its history, Microsoft has put together a range of impressive case studies, which involve large databases that went operational on the beta of SQL Server 2005. In addition, Microsoft has been using the database engine, for real, on more than 65 of its own, internal, applications.

Paul Flessner, SVP at Microsoft, says:

In addition to running the full SAP, payroll, expense, tax data warehouse, and document repository systems, Microsoft now has more than 10 instances of SQL Server 2005 that are storing multiple terabytes of data. These SQL Server 2005 installations have been responsible for processing more than 7 billion, yes billion, transactions against our SAP system SQL Server 2005 database, which includes processing close to 3 million invoices and over 1.6 million sales orders

Return to Page 1 of main article here - otherwise use "back" button.

Sponsored: Designing and building an open ITOA architecture