September 14, 2010 at 12:46 pm
Is it Ok if we install SQL SErver standard 32 bit version on win 2003 64 bit ? and is there a way to upgrade sql server from 32 bit to 64 bit or do i have to re install the sql server?
September 14, 2010 at 1:13 pm
Also what would be the benefits of 64 bit over 32 bit for sql server?
September 14, 2010 at 1:24 pm
SQL Server 32 bit cannot be upgraded to 64 bit. It needs to be reinstalled. This whitepaper explains the benefits of 64 bit architecture.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
September 14, 2010 at 1:39 pm
In my eyes the biggest benefits of 64 over 32 is memory usage and taking full advantage of the newer hardware(true hyper-threading) that continues to come available you know HT was built for 64 bit but made to work with 32 bit systems. I hope you dont have to rebuild your sytem and can just stay with the current 32 bit at least for now but if you can may as well upgrade and take full adbvantage of it. Good Luck.
DHeath
September 14, 2010 at 2:47 pm
Yes, you can install x86 on your x64 system - but why do you think you need to do that? There are a few known issues where you would need to install the 32-bit version, but if you are not in one of those situations you should install the 64-bit version.
Generally, the only time you need to install x86 version on x64 is if you have a requirement to use a linked server that does not have an x64 driver available.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 14, 2010 at 3:09 pm
DHeath (9/14/2010)
In my eyes the biggest benefits of 64 over 32 is memory usage and taking full advantage of the newer hardware(true hyper-threading) that continues to come available you know HT was built for 64 bit but made to work with 32 bit systems. I hope you dont have to rebuild your sytem and can just stay with the current 32 bit at least for now but if you can may as well upgrade and take full adbvantage of it. Good Luck.
Hyperthreading is a disaster waiting to happen on a dedicated SQL server...I've had nothing but problems with it, especially in SQL 2K5. I disable HT on every server I have.
Unless of course, you mean multithreading, and not Intel's quasi-virtual-core that I was talking about.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply