SQL2005 x86-x64 performance comparison

18 Mar 2006 3:17 PM

Tom

Did anyone tested and compare the performance of SQL2005 x86 and x64
edition?
What the performance boost is in a real production environments not just
what Microsoft demos and presentations show us.
If you have a server with at least 8GB or more RAM (where x64 should kick
in) and first run win2003 x86 with SQL2005 x86 on it and then reinstall the
sistem to win2003 x64 with SQL2005 x64 - has anyone experienced some real
boost and what kind of load were you running?

Tom

19 Mar 2006 12:38 PM

Hilary Cotter

For most work loads it is significant, so much so that many if not most
companies many are no longer deploying in production on 32bit machines. I
don't have numbers as they vary as you get better cpu usage, better indexing
performance, and you are able to see/use more RAM (although the story is a
little complicate on SQL 2000).

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

Show quoteHide quote

"Tom" <mcse***@hotmail.com> wrote in message
news:O5MHF8pSGHA.4300@TK2MSFTNGP14.phx.gbl...
> Did anyone tested and compare the performance of SQL2005 x86 and x64
> edition?
> What the performance boost is in a real production environments not just
> what Microsoft demos and presentations show us.
> If you have a server with at least 8GB or more RAM (where x64 should kick
> in) and first run win2003 x86 with SQL2005 x86 on it and then reinstall
> the sistem to win2003 x64 with SQL2005 x64 - has anyone experienced some
> real boost and what kind of load were you running?
>
> Tom
>

19 Mar 2006 8:47 PM

Linchi Shea

It's difficult to answer this type of questions without running the risk of
being misinterpreted. But the short answer is that you may not want to expect
automatic performance boost going from 32-bit to 64-bit in all cases. For
some workloads especially those with significant demand on memory, you'll see
performance boost. For other cases, you may not see much change.

In the end, I'd choose to test my app on both platforms and find out for
myself before I decide which platform I should go with no matter what I may
hear here or elsewhere.

Linchi

Show quoteHide quote

"Tom" wrote:

> Did anyone tested and compare the performance of SQL2005 x86 and x64
> edition?
> What the performance boost is in a real production environments not just
> what Microsoft demos and presentations show us.
> If you have a server with at least 8GB or more RAM (where x64 should kick
> in) and first run win2003 x86 with SQL2005 x86 on it and then reinstall the
> sistem to win2003 x64 with SQL2005 x64 - has anyone experienced some real
> boost and what kind of load were you running?
>
> Tom
>
>
>

20 Mar 2006 5:05 AM

HK

It's a great question, but if you're trying to make a purchasing decision,
definitely go 64 bit. Everything is going 64 bit, and if you learn from the
past (sql 2000 to sql 2005), it will be many years before the next version
of sql server. I wouldn't want to change in the middle of having live
databases when I could just start with 64 bit during an upgrade to SQL 2005
now.

Show quoteHide quote

"Tom" <mcse***@hotmail.com> wrote in message
news:O5MHF8pSGHA.4300@TK2MSFTNGP14.phx.gbl...
> Did anyone tested and compare the performance of SQL2005 x86 and x64
> edition?
> What the performance boost is in a real production environments not just
> what Microsoft demos and presentations show us.
> If you have a server with at least 8GB or more RAM (where x64 should kick
> in) and first run win2003 x86 with SQL2005 x86 on it and then reinstall
the
> sistem to win2003 x64 with SQL2005 x64 - has anyone experienced some real
> boost and what kind of load were you running?
>
> Tom
>
>