32bit vs 64bit SQL 2005

Just curious if anyone has any numbers for this.
We have a customer that has their server running windows server 64bit.
But, SQL 2005 loaded on it is only 32bit. What would be the benefits
(speed mainly) of upgrading to 64bit SQL - in numbers - like a 25%
increase, or something like that. Or, is there some certain issue when
running the 32bit SQL on 64bit OS that I need to be aware of.
TIA
Darin
*** Sent via Developersdex http://www.developersdex.com ***The immediate benefit would be an improvement in the accessibility of memory
past 2GB (you wouldn't need to have AWE enabled - and AWE has restrictions
and is slow to deal with compared to normal memory).
I personally wouldn't expect a massive performance difference between 32-bit
vs. 64-bit on a 64-bit box, although 25% might not be unrealistic (have seen
this kind of performance difference with 32-bit Integration Services running
on a 64-bit box).
"Darin" <darin_nospam@.nospamever> wrote in message
news:u0FNa53WIHA.484@.TK2MSFTNGP06.phx.gbl...
> Just curious if anyone has any numbers for this.
> We have a customer that has their server running windows server 64bit.
> But, SQL 2005 loaded on it is only 32bit. What would be the benefits
> (speed mainly) of upgrading to 64bit SQL - in numbers - like a 25%
> increase, or something like that. Or, is there some certain issue when
> running the 32bit SQL on 64bit OS that I need to be aware of.
> TIA
> Darin
> *** Sent via Developersdex http://www.developersdex.com ***|||I don't know that there can be an explicit across the board answer for this
situation. It probably depends on the load on the server. The more heavily
loaded the server runs the better the 64bit sql server install should
perform.
--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"Darin" <darin_nospam@.nospamever> wrote in message
news:u0FNa53WIHA.484@.TK2MSFTNGP06.phx.gbl...
> Just curious if anyone has any numbers for this.
> We have a customer that has their server running windows server 64bit.
> But, SQL 2005 loaded on it is only 32bit. What would be the benefits
> (speed mainly) of upgrading to 64bit SQL - in numbers - like a 25%
> increase, or something like that. Or, is there some certain issue when
> running the 32bit SQL on 64bit OS that I need to be aware of.
> TIA
> Darin
> *** Sent via Developersdex http://www.developersdex.com ***|||I don't think you can really quantify the performance without actually
running tests in your environment. See
http://blogs.msdn.com/sqlprogrammability/default.aspx.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Darin" <darin_nospam@.nospamever> wrote in message
news:u0FNa53WIHA.484@.TK2MSFTNGP06.phx.gbl...
> Just curious if anyone has any numbers for this.
> We have a customer that has their server running windows server 64bit.
> But, SQL 2005 loaded on it is only 32bit. What would be the benefits
> (speed mainly) of upgrading to 64bit SQL - in numbers - like a 25%
> increase, or something like that. Or, is there some certain issue when
> running the 32bit SQL on 64bit OS that I need to be aware of.
> TIA
> Darin
> *** Sent via Developersdex http://www.developersdex.com ***sql