Feeds

SQL Server and Scalability

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

  • alert
  • submit to reddit

Secure remote control for conventional and virtual desktops

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.

The essential guide to IT transformation

More from The Register

next story
The Return of BSOD: Does ANYONE trust Microsoft patches?
Sysadmins, you're either fighting fires or seen as incompetents now
Munich considers dumping Linux for ... GULP ... Windows!
Give a penguinista a hug, the Outlook's not good for open source's poster child
Intel's Raspberry Pi rival Galileo can now run Windows
Behold the Internet of Things. Wintel Things
Linux Foundation says many Linux admins and engineers are certifiable
Floats exam program to help IT employers lock up talent
Microsoft cries UNINSTALL in the wake of Blue Screens of Death™
Cache crash causes contained choloric calamity
Eat up Martha! Microsoft slings handwriting recog into OneNote on Android
Freehand input on non-Windows kit for the first time
prev story

Whitepapers

Implementing global e-invoicing with guaranteed legal certainty
Explaining the role local tax compliance plays in successful supply chain management and e-business and how leading global brands are addressing this.
Top 10 endpoint backup mistakes
Avoid the ten endpoint backup mistakes to ensure that your critical corporate data is protected and end user productivity is improved.
Top 8 considerations to enable and simplify mobility
In this whitepaper learn how to successfully add mobile capabilities simply and cost effectively.
Rethinking backup and recovery in the modern data center
Combining intelligence, operational analytics, and automation to enable efficient, data-driven IT organizations using the HP ABR approach.
Reg Reader Research: SaaS based Email and Office Productivity Tools
Read this Reg reader report which provides advice and guidance for SMBs towards the use of SaaS based email and Office productivity tools.