Ads by TechWords

See your link here
Receive the latest technology news and information.
Computerworld Daily News (First Look and Wrap-Up)
Computerworld Blogs Newsletter
The Weekly Top 10
Cloud Computing
View all newsletters




Privacy Policy
 

Microsoft Releases 64-bit SQL Database

Enterprise Edition touted as Unix alternative

April 28, 2003 12:00 PM ET

Computerworld - 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.



Jump to comments

Databases

Additional Resources

WHITE PAPER
Approximately 60 percent of data migration projects overrun time or budget, while some fail completely. Download this white paper, "Enhancing Your Chance for Successful Data Migration," to learn the critical steps you need to take to execute a data migration project with minimum cost and risk to your business.
WHITE PAPER
Read the Gartner research note to learn why the TCO of a server-based computing deployment used to deliver all applications to users is around 50% lower than that of an unmanaged desktop deployment.
WHITE PAPER
Economic downturns have a tendency to accelerate emerging technologies, boost the adoption of effective solutions, and punish solutions that are not cost competitive or that are out of synch with industry trends. This IDC White Paper presents the results of an IDC survey of 330 companies in Western Europe, Asia/Pacific and the Americas that measures the receptiveness to Linux and takes into consideration changing views driven by the disruptive economic environment that businesses face today.

White Papers & Webcasts

Optimize Performance of Datacenter to Datacenter Traffic
To get the backups and database synchronizations completed on time, enterprises rely on WAN optimization from Blue Coat.  

Handling Unpredictable Queries
Row-based DB Limitations  

Strategic ECM Webinar
Learn what new strategic business benefits can be realized through ECM!

Sybase® IQ: The Economics of Business Reporting
Download this white paper today!  

Gaining the Performance Edge Using a Column-Oriented Database Management System
A Different Approach: Column-Oriented Data Management Systems  

Tabor Research: NFS Evolution Changes the Landscape of HPC Data Management
A hybrid file system combining the benefits of standard NFS and the performance and scale of parallel file systems.  

Effectively Implementing Datacenter Automation
Effectively select and deploy the best datacenter automation solution today!

 

SAS Information Management Kit

SAS is the leader in business intelligence and analytical software and services. Only SAS offers leading data integration, storage, analytics and business intelligence applications within a comprehensive enterprise intelligence platform. SAS gives 97 of the top 100 companies in the 2007 Fortune 500 THE POWER TO KNOW®.

Webcast: The Information Management Roadmap
Imagine high-quality data, cleansed, analyzed and delivered throughout your organization. Join Computerworld, IT visionary Thornton May and a panel of experts to learn how SAS® can help you make it happen.

View this webcast 
Research Report: Information Management Initiatives at Midsize and Large Organizations
See the top-line results of this Computerworld sponsored survey to see how IT and business leaders are handling information management implementation.

Download this report 
White Paper: Information Management: Better Information for Winning Decisions.
This white paper explains how the SAS Information Evolution Model aids companies in assessing how they use this information to make strategic decisions and drive business.

Download this white paper