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.codecomments.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.codecomments.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.codecomments.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.codecomments.com ***
|||This server is the distributor for 2 replicated subscribers.
One question - does 32bit SQL 2005 ONLY use 2GB RAM? If so, that to me
is enough reason to upgrade.
All 3 servers have 64bit Windows but are only running 32bit SQL2005.
Also, the distributor has 3GB RAM, one subscriber has 4GB and the other
has 2.93GB RAM. I have told their IT person to put at least 4GB on the
distributor since that is in the main office w/ the most users, and is
handling the replication.
Darin
*** Sent via Developersdex http://www.codecomments.com ***
|||> One question - does 32bit SQL 2005 ONLY use 2GB RAM? If so, that to me
> is enough reason to upgrade.
Memory in Standard Edition (and above) is limited only by the OS. However,
in 32-bit versions, memory beyond 3GB can be used only for data buffer cache
and is addressable only via AWE. One the the reasons to migrate to 64-bit
is that memory beyond 3GB can be used for other memory needs, like procedure
cache.
Hope this helps.
Dan Guzman
SQL Server MVP
"Darin" <darin_nospam@.nospamever> wrote in message
news:eGsq6P4WIHA.5132@.TK2MSFTNGP02.phx.gbl...
> This server is the distributor for 2 replicated subscribers.
> One question - does 32bit SQL 2005 ONLY use 2GB RAM? If so, that to me
> is enough reason to upgrade.
> All 3 servers have 64bit Windows but are only running 32bit SQL2005.
> Also, the distributor has 3GB RAM, one subscriber has 4GB and the other
> has 2.93GB RAM. I have told their IT person to put at least 4GB on the
> distributor since that is in the main office w/ the most users, and is
> handling the replication.
> Darin
> *** Sent via Developersdex http://www.codecomments.com ***