Re: 32 bit SQL vs 64 bit

Tech-Archive recommends: Fix windows errors by optimizing your registry

The decision point varies for different users. A hardware refresh is a good time to consider 64-bit. Performance or scalability problems tracable to hardware limitations are also a good reason to consider an upgrade. The only reason I would see not to use 64-bit is if you need to access many non-SQL data sources. The supply of 64-bit ODBC drivers is a bit limited.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP




"Chris Wood" <anonymous@xxxxxxxxxxxxx> wrote in message news:uyU$ZI5$HHA.536@xxxxxxxxxxxxxxxxxxxxxxx
Geoff,

Is there anywhere that defines the moment that 64 bit should replace 32 bit rather than the hardware that you want to run on? We look like we should be moving up to 64 bit.

Thanks

Chris

Nice to meet you at PASS last week.

"Geoff N. Hiten" <SQLCraftsman@xxxxxxxxx> wrote in message news:eBVgWFv$HHA.5652@xxxxxxxxxxxxxxxxxxxxxxx
Unless you have a compelling reason such as external driver compatibility, I would definitely recommend 64-bit SQL for a highly scaled system.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Gates" <gates@xxxxxxxxxxx> wrote in message news:O$nSKpu$HHA.4496@xxxxxxxxxxxxxxxxxxxxxxx
We are setting up a new beefy SQL database. I've got 32GB's of Ram. Everything I've been reading it looks like 64 bit is the way to go. Anyone have any thoughts on 32 vs 64?

Thanks,
Gates





.

Relevant Pages

  • Re: Integration services. High availability configuration
    ... Senior SQL Infrastructure Consultant ... Microsoft SQL Server MVP ... "Geoff N. Hiten" wrote in message ...
    (microsoft.public.sqlserver.clustering)
  • Re: 8 node active/active cluster
    ... Senior SQL Infrastructure Consultant ... Microsoft SQL Server MVP ... "Geoff N. Hiten" wrote in message ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL 2005 Active/Passive
    ... It is safest to run the installer when the node is not currently hosting anything, ... Senior SQL Infrastructure Consultant ... Microsoft SQL Server MVP ... "Geoff N. Hiten" wrote: ...
    (microsoft.public.sqlserver.clustering)
  • Re: Active/Active/Passive cluster Newb question...
    ... Hardware can sometimes help, but bad database design and poorly written queries will overwhelm even the best hardware. ... Geoff N. Hiten ... Senior SQL Infrastructure Consultant ...
    (microsoft.public.sqlserver.clustering)
  • Re: error during install
    ... "Geoff N. Hiten" wrote: ... Senior SQL Infrastructure Consultant ... The install is coming from media in node 1's dvd player. ... Source File Name: sqlchaining\highlyavailablepackage.cpp ...
    (microsoft.public.sqlserver.clustering)