Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Still 32


Still 32

Author
Message
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36111 Visits: 18742
Comments posted to this topic are about the item Still 32

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Andy Leonard
Andy Leonard
Mr or Mrs. 500
Mr or Mrs. 500 (509 reputation)Mr or Mrs. 500 (509 reputation)Mr or Mrs. 500 (509 reputation)Mr or Mrs. 500 (509 reputation)Mr or Mrs. 500 (509 reputation)Mr or Mrs. 500 (509 reputation)Mr or Mrs. 500 (509 reputation)Mr or Mrs. 500 (509 reputation)

Group: General Forum Members
Points: 509 Visits: 1092
Excellent points, Steve,

Each time I'm reminded of the decision to not build 64-bit Excel drivers I think, "Think of all the money they saved!" Meanwhile, I've seen data integration shops struggle with the overhead of learning to execute SSIS in 32-bit mode to accommodate that decision.

:{\

Andy Leonard
Data Philosopher, Enterprise Data & Analytics
chrisn-585491
chrisn-585491
SSC Eights!
SSC Eights! (950 reputation)SSC Eights! (950 reputation)SSC Eights! (950 reputation)SSC Eights! (950 reputation)SSC Eights! (950 reputation)SSC Eights! (950 reputation)SSC Eights! (950 reputation)SSC Eights! (950 reputation)

Group: General Forum Members
Points: 950 Visits: 2316
We've had two plus decades of sales pressure and promotion from Redmond and others "encouraging" us to upgrade. After a while users realize that the newer versions of software aren't always necessary or anymore useful than the older ones and in some cases, (Vista, Windows 8, etc...), they can be confusing and costly to implement.
GilaMonster
GilaMonster
SSC-Forever
SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)

Group: General Forum Members
Points: 47241 Visits: 44377
I've been running 64 bit on my home machine for over 5 years now. Some software is installed 64 bit, most as 32 bit. Minimal problems, most were VPN clients that didn't have 64-bit drivers (hello virtual machine).

I'd honestly recommend 64 bit OS without exception. SQL too, unless there's a really, really good reason not to.


Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


majorbloodnock
majorbloodnock
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1113 Visits: 3062
I was listening to a presentation recently and the presenter talked about some of the restrictions in working with 32 bit SQL Server on 64 bit Windows hosts. Another person joked that any companies still running 32 bit software were way behind the times. I heard a comment that surely everyone runs 64 bit hardware these days, don't they?

I can picture the scene perfectly in my mind's eye. Throwaway comments from techies being arrogant or smug, or simply making unsafe assumptions. None of those are attributes to fill me with confidence in those techies' abilities.

I agree that 64 bit is a good and perfectly safe choice, but there are always edge cases. Just because something's a good choice if you have a blank canvas isn't sufficient justification for all other setups to be updated. Technical excellence and fitness for business purpose are not always the same thing.

Semper in excretia, sumus solum profundum variat
Dave62
Dave62
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3051 Visits: 2715
Good editorial Steve!

I vaguely remember a similar debate, many years ago, regarding 16 or 32 bit. I guess the more things change the more they stay the same. Laugh

There may be a few places where 16 bit is still running fine but for the most part it has been replaced. If history is any indicator the same will be true for 32 bit. As new hardware and software comes out 64 bit will slowly become the standard and there will be fewer and fewer places where 32 bit continues to run fine.

It will be interesting to see what kind of breakthrough will be discovered to replace 64 bit...

Enjoy!
TravisDBA
TravisDBA
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1462 Visits: 3069
We have one legacy 32-Bit SQL box. The rest are all 64-Bit installs. It's our standard install simply because 64-bit architecture blows right past the 3 GB barrier and can theoretically address up to 18 Exabytes (18 billion GB) of system memory, not that you would ever have that much memory. Plus, 64-bit computers are much faster and more efficient than 32-bit computers because the processor can swallow and digest larger chunks of data with each and every bite. So, they are the hands down choice over 32-bit systems. Anyway, that architecture is extremely dated and is dying a very fast death.:-D

"Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ...:-D"
Andrew-H
Andrew-H
SSC Rookie
SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)

Group: General Forum Members
Points: 26 Visits: 177
We run 64 bit for most new builds with one exception, some old finical reporting software that is tied to our ERP system requires 32 bit. This software is no longer being developed or upgraded by the vendor. We cannot switch to another tool without writing it ourselves and that will not happen because the ERP system will be upgraded to a different vendor soon. …by soon I mean they will start working on the upgrade soon. So, long story short, we still have at least 2 years on 32 bit for this dusty old software.
lptech
lptech
Old Hand
Old Hand (345 reputation)Old Hand (345 reputation)Old Hand (345 reputation)Old Hand (345 reputation)Old Hand (345 reputation)Old Hand (345 reputation)Old Hand (345 reputation)Old Hand (345 reputation)

Group: General Forum Members
Points: 345 Visits: 3275
There are always people who will be penny wise and pound foolish. Servers need to be replaced, so why not take advantage of more powerful hardware? Not everybody wants to be bleeding edge, but certainly no need to wait more than 1-2 years. Also, people get paid with real money. So it's a waste of time and money to spend endless time working of performance issues that could be solved with hardware that costs less than the salary for all those involved. The business would be better served if said individuals were working on new systems.

The vendor app issue is the one thing that can be really hard to get around. I remember a few times over the years when the business was perfectly happy with the older version that hadn't been certified newer versions of just about everything.
Revenant
Revenant
SSCertifiable
SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)

Group: General Forum Members
Points: 5777 Visits: 4713
I am surprised that no one mentioned the 2 GB (or 3 GB under Win7) memory limit. In my experience, need for more memory is a pretty good reason to go to 64 bits.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search