SQL Server 64-bit undercuts RISC rivals

Daily Newsletters

Sign up to ZDNet UK's daily newsletter.

NEWS
When Microsoft launches its 64-bit version of SQL Server at the end of this month, the database will cost the same as the 32-bit version, give much better performance, and be part of the company's bid to oust Oracle and IBM's DB/2 on high end systems. SQL Server is widely regarded as suitable for smaller systems, while larger databases are the province of Oracle or DB/2 running on RISC systems. However, Microsoft has been quietly creeping up the rankings, and last month a pre-launch version of 64-bit SQL Server reached number 2 in the non-clustered TPC-C benchmark performance table running on an NEC Itanium 2 mainframe. "We are not stopping at number two," said Mitch Gatchalian, product manager for SQL Server 2000 Enterprise Edition (the 64-bit version). "Last year in October, we came in at number 6, and have ramped up quickly, to reach number two. Sixty four-bit Itanium 2 will be a big turning point." Microsoft already tops the league in clustered performance, and for benchmarks where the number of processors is limited. Gatchalian pointed out that when price per transaction is taken into account, Microsoft gains considerably. The biggest advantage of Itanium over x86 processors is the addressable memory. Although 16 exabytes -- one exabyte being a billion gigabytes -- is more than anyone needs right now, the fact that it can directly address more than the 4Gbyte limitation of 32-bit systems means it can perform database manipulations in memory easily without paging to disk, said Gatchalian. The 64-bit version will be sold to existing Microsoft customers and to those with other databases: "We have a high level of compatibility with the existing SQL Server database," Gatchalian said. "The SQL code is compatible, and the database file format is the same. You simply detach from the 32-bit server and re-attach." Pricing the 64-bit version the same as the 32-bit version is intended to ease that upgrade: "Customers who have budgeted for SQL server don't have to go back and ask for more money." However, Gatchalian did not address the issue that a 64-bit database will require a more expensive 64-bit operating system and 64-bit hardware on which to run. SQL Server still has a very small market share at the high end, Gatchalian concedes, but he claims that many RISC customers are coming to him asking to migrate, to get better performance and lower cost: "There is a significant market out there in high scale servers systems that Microsoft and Intel has not tapped." In the high end, there are fewer new databases set up, so much of the business must come from migration. Microsoft has offered tools and guides to move data into SQL Server -- and these will work just as well for the 64-bit version, said Gatchalian, because of the compatibility between the versions. He gave no predictions of SQL Server's market share in the 64-bit space. "It depends on how aggressively Intel sells 64-bit," he said. "Itanium has had a slow start, but Itanium 2 will be a sharp curve. We are at the bottom part of that curve now."
For a weekly round-up of the enterprise IT news, sign up for the Enterprise newsletter. Tell us what you think in the Enterprise Mailroom.

Post your comment

In order to post a comment you need to be registered and logged in.

You can also log in with Facebook. Log in or create your ZDNet UK account below

  • Login

Will not be displayed with your comment

By signing up for this service, you indicate that you agree to our Terms and Conditions and have read and understood our Privacy Policy. Questions about membership? Find the answers in the Community FAQ

Get ZDNet UK's daily newsletter

Enter your email address to sign up

ZDNet UK Live

45283

I think WinRT is fantastic. I just wish it was an option for people that didn't want to go through Microsoft's App Store with its attendant...

2 hours ago by 45283 on Why Windows 8 needs architectural hygiene for WOA
Burn-IT

Nine people? £30m? Who's back pocket is that lot going in? And IF they say it is for new buildings, what about all the ones the government has...

3 hours ago by Burn-IT on Police set to launch three £30m e-crime hubs
ewallace

Just to be clear, nobody knows what is in the text of ACTA, here is a photograph of the text of ACTA http://twitpic.com/8h9iju as submitted to the...

4 hours ago by ewallace on ACTA: Facts, misconceptions and questions
fgvrg56

Unfortunately main issue is that ASUS is refusing to accept that they make some mistake on this version of asus Transformer prime. 1 - GPS sensor...

5 hours ago by fgvrg56 on Asus Eee Pad Transformer Prime Wi-Fi & GPS problems?
Ben Woods

@Marcus A fair question. Just talked with Archos which said it was working on an announcement for next week....

6 hours ago by Ben Woods on Archos confirms G9 Ice Cream Sandwich update schedule
Marcus Karlsson

Any update on this, considering the claimed "first week of February"?

7 hours ago by Marcus Karlsson via Facebook on Archos confirms G9 Ice Cream Sandwich update schedule
apexwm

Bill Goodrich : Just as al_langevin pointed out, with Windows Server 2008 there is no Services for Macintosh anymore. It's gone, not available....

15 hours ago by apexwm on Windows Server 2008 drops the ball for Mac compatibility
txtrainguy

Replying to an old topic that I'm currently facing with my CEO (who is on a Mac). Our servers are primarily Windows Servers, office is about...

22 hours ago by txtrainguy on Windows Server 2008 drops the ball for Mac compatibility
k0tcs3

Sure, that makes perfect sense. Pay wrong-doers money and thank them for breaching your security and pointing out your flaws, that would surely...

22 hours ago by k0tcs3 on US indicts Romanian over NASA climate change hack
Random_Error

I think he's referring specifically to Android apps, as Apple do regulate their App Store, but Google seem to let any old crap onto the Android store!

22 hours ago by Random_Error on RIM: BlackBerry will keep 'garbage' apps out of store
Paul Fezziwig

Keep the crap apps out?! How will they compete with Android and Apple's claim to fame of having so many life changing apps? I wonder if the media...

1 day ago by Paul Fezziwig via Facebook on RIM: BlackBerry will keep 'garbage' apps out of store
Aigars Mahinovs

It has been shown time after time that if there is an author store that sells the songs at even 1$ per song and gives you a high-quality digital...

1 day ago by Aigars Mahinovs via Facebook on Copyright isn't working, says European Commission
awbMaven

""As a result of Butyka's alleged conduct, researchers were unable to use the computers for more than two months while NASA removed the malicious...

1 day ago by awbMaven on US indicts Romanian over NASA climate change hack
subhorup

It simultaneously worries me and uplifts me that a self-proclaimed group of internet activists name themselves after Indian mythical figures....

2 days ago by subhorup on Anonymous activists release PCAnywhere source code
naviathan

It's actually far easier to work anonymously on the internet than you think. With tools like Tor bouncing your traffic around the world before...

2 days ago by naviathan on Anonymous activists release PCAnywhere source code
Agnostic_OS

1000272134 and bluedalmatian with you both there but then I'm still in 10.04 land (and happy with it)

2 days ago by Agnostic_OS on Ten factors that make Ubuntu 11.10 a hit
apexwm

Interesting article and definitely see your points on the products mentioned. One of the top products for our Help Desk (approximately 20% of all...

2 days ago by apexwm on Ten flawed products that derail productivity
Paul Hutchinson

Absolutely - this should obviously not be handled my isp - but handled by their hosting operator. What's been suggested here is that my isp police...

2 days ago by Paul Hutchinson via Facebook on MPs urge ISPs to take down terrorist material
Techs UK

Looks like a great phone. I don't notice any deficiencies in WP7. used IOS before, that's pretty good. I don't spend much time in Apps, all i need...

2 days ago by Techs UK on Nokia pins US 're-entry' hopes on Lumia 900
Larry Bloggy

Now with the help of these apps you are always synced with MS outlook while on the move. Just download apps like xobni or outlookreflex and get...

2 days ago by Larry Bloggy via Facebook on Outlook Social Connector beta 2 and the LinkedIn connector

Latest in Application Development