Re: 32 bit SQL vs 64 bit

As Geoff says the hardware upgrade is right time to move to 64 bit, most of
the new servers come with x64 processors, there are no additional licensing
fees for Windows as well as SQL Server 2005 moving from 32 to 64 bit.

"Geoff N. Hiten" <SQLCraftsman@xxxxxxxxx> wrote in message
news:%23EhsX85$HHA.2268@xxxxxxxxxxxxxxxxxxxxxxx
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: Need Feedback on Trans. Replication w/ Remote Distributor
    ... Geoff N. Hiten ... Microsoft SQL Server MVP ... Transactional replication will give you a read-only copy of the ... >> Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.replication)
  • Re: Slow update
    ... Thanks for your comments - time to invest in some books me thinks! ... Geoff ... I'm afraid I don't know much about the SQL server itself ...
    (microsoft.public.dotnet.languages.vb)
  • Re: SQL 2000 Load Balancing Question
    ... the upper limits of hardware are well beyond what any decently ... Microsoft SQL Server MVP. ... >> database, is not possible with SQL Server 2000. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server 2000 Hardware
    ... SQL Server 2000 Standard Edition supports 2GB of RAM. ... RAID volume for your database files, a separate RAID volume for the log ... hardware to support clustering. ...
    (microsoft.public.sqlserver.setup)
  • Re: Connecting to an instance in a cluster
    ... Each virtual server has its own IP address so you can reuse port numbers between instances. ... Microsoft SQL Server MVP ... "Geoff N. Hiten" wrote: ...
    (microsoft.public.sqlserver.clustering)