Microsoft Releases 64-bit SQL Database
Enterprise Edition touted as Unix alternative
April 28, 2003 12:00 PM ETComputerworld -
Microsoft Corp. has released a 64-bit database and claims that the new system features performance rivaling that of Unix-based systems yet offers greater ease of use and at a lower cost.
In conjunction with the launch of Windows Server 2003, Microsoft last week announced that it's shipping the 64-bit SQL Server 2000 Enterprise Edition. With the move, Microsoft follows in the footsteps of Oracle Corp. and IBM, which have offered 64-bit versions of their databases for Unix and mainframe systems for years.
Oracle, meanwhile, announced the availability of a version of Oracle9i Database Release 2 that's optimized for 64-bit Windows Server 2003.
Microsoft's 64-bit version of its SQL Server database gives high-end database users an alternative to Unix, said Sheryl Tullis, Microsoft's product manager for SQL Server. "For customers that need high-powered computing, this makes it attainable without the upfront maintenance and management costs of Unix systems," she said.
Tests indicate that the database will have 512GB of addressable memory, double what was available under 32-bit SQL Server.
Forest Hills, N.Y.-based airline JetBlue Airways Corp. in December went live with a 64-bit SQL Server database that supports the company's frequent-flier application, said CIO Jeff Cohen. JetBlue is building a 64-bit SQL Server-based data warehouse to run customer analytics, Cohen said.
The airline is currently running 32-bit SQL Server to support internal business applications and an Oracle database for special aviation applications. Cohen said that when using the 32-bit SQL Server for the frequent-flier application, JetBlue had to keep adding more servers and processors to maintain performance. With a 64-bit architecture, the company was able to shrink a three-server Compaq ProLiant system with 12 processors to one four-way Hewlett-Packard Co. server.
"We were very thrilled by performance," said Cohen, who added that 64-bit SQL requires only 10% to 20% CPU utilization, as opposed to as much as 60% with 32-bit SQL.
But aside from the very few organizations that have a need for "serious number crunching," there will be a limited demand for 64-bit SQL Server, said James Governor, an analyst at RedMonk, a consulting firm in Hollis, N.H. "It's the same as ever with 64-bit. It's a technology in search of a mass-market application. Sixty-four bit is a 'nice to have,' not a 'need to have' in many cases."
According to Tullis, Microsoft has commitments from business software vendors Siebel Systems Inc., PeopleSoft Inc. and SAP AG to optimize their software for the 64-bit version of SQL Server.
Additional Resources



Learn the important issues you must consider before starting your next mobility initiative. Get your mobility white paper from IDC now, compliments of Sybase.
White Papers & Webcasts
Keep it Clean: Maintaining the Integrity of your CMDB through Change Detection
Learn how configuration drift can challenge configuration management database (CMDB) integrity and how a configuration audit tool and an effective change management process...
Improving Quality of Service for Oracle Database with My Oracle Support
(Source: Oracle) Oracle's Willie Hardie and Oracle Support Expert Sean Bingham discuss how My Oracle Support optimizes the quality of support provided to...
Tapping the Full Potential of Sales and Marketing Data for Pharmaceuticals
As pharmaceutical manufacturers face an era of sharply reduced sales and marketing budgets, increasingly complex and restrictive regulations, and rapidly changing demand patterns...
Usability Is Everything
Learn what sets Workday's HR and Payroll solutions apart from the competition....
Bloor Research: Netezza and the HP Oracle Database Machine
HP and Oracle have recently announced the HP Oracle Database Machine. This has been positioned by Oracle as a competitor to Netezza and...
The Value of Real SaaS at Workday
Cost savings, speed to value, and innovation brought to the enterprise by Workday's software-as-a-service solutions for HR and Payroll....
Risk Readiness and Redundancy: PCI Compliance Automation
(Source: Symantec) This paper examines compliance regulations surrounding the Payment Card Industry Data Security Standards, the challenges it puts on IT Security and...
SaaS at Flextronics, Inc.
Dave Smoley, CIO of Flextronics, discusses the real value of software-as-a-service and why he chose Workday for his HR solution....
How to Populate Your CMDB in Four Steps
Generally, CMDBs populated by discovery tools alone simply aren't usable. They fail because they contain massive amounts of irrelevant information. You avoid this...
Why Compliance Pays
This OnDemand webcast explores the relationship that firms with best compliance records have higher revenue, greater customer retention, lower financial losses from data...
Subscribe to Computerworld

