32 bit sql 2005 on 32 bit OS or 64 bit OS

generic

Hello

Client is buying a new hardware and I wanted to know which would perform better.

The sql server is 32 bit, so they won't change that.


The question is will 32 bit sql 2005 perform better on 32 bit OS or on 64 bit OS?


Also the max memory is 4 gig.

With 64 bit you can have more memory for OS and 4 gig for sql.

Also I'm guessing moving from 32 bit sql to 64 bit sql require new license?

Thanks.

bbrown

generic wrote:

Hello...
Also I'm guessing moving from 32 bit sql to 64 bit sql require new license?

Thanks.

Depends on how SQL was licensed. If Retail or OEM, then yes. If thru a volume purchase agreement, then all you need is the 64 bit media.

David_Singleton

Upgrade the OS to 64bit. I don't think you can even install 64bit SQL on a 32 bit OS.

David_Singleton

bbrown wrote:

generic wrote:

Hello...
Also I'm guessing moving from 32 bit sql to 64 bit sql require new license?

Thanks.

Depends on how SQL was licensed. If Retail or OEM, then yes. If thru a volume purchase agreement, then all you need is the 64 bit media.

I have had clients with both Retail and OEM that went back to Microsoft and got 64bit upgrades at very low cost, as in less than $100. Generally its just media cost and an administration fee.

bbrown

David Singleton wrote:

bbrown wrote:

generic wrote:

Hello...
Also I'm guessing moving from 32 bit sql to 64 bit sql require new license?

Thanks.

Depends on how SQL was licensed. If Retail or OEM, then yes. If thru a volume purchase agreement, then all you need is the 64 bit media.

I have had clients with both Retail and OEM that went back to Microsoft and got 64bit upgrades at very low cost, as in less than $100. Generally its just media cost and an administration fee.

Yes, I've had that happen too. I've also have OEM vendor swap out the products. But these have usually been situations where the customer had not had the license for long and/or was on a current version. But either way it is worth a try.

generic

thank you.

Slawek_Guzek

bbrown wrote:

Depends on how SQL was licensed. If Retail or OEM, then yes.

No, it does not depends. You are free to install 32 or 64 bit SQL, the only problem is with media.

Volume licence clients receive both 32 and 64 bit version. Retail and OEM not, so Microsoft just suggest to contact your retailer for help getting media with proper server version.

http://www.microsoft.com/servers/64bit/faqs.mspx#EOB

Regards,

Slawek_Guzek

The question is will 32 bit sql 2005 perform better on 32 bit OS or on 64 bit OS?

If machine has only 4 GB of total RAM then 32bit SQL will definitely perform better on 32bit OS, although the differences will not be probably noticeable.

Running 32bit app on 64bit OS requires additional level of software running in between OS and application (WOW subsystem), and there will be no benefits from increased memory available to SQL.

Regards,

Slawek_Guzek

David Singleton wrote:

Upgrade the OS to 64bit. I don't think you can even install 64bit SQL on a 32 bit OS.

SQL is 32 bit and will stay 32 bit, so question is 32 or 64bit OS.

Even if SQL could be updated to 64 bit updating both SQL and OS to 64bit with only 4 GB of total RAM in machine makes no sense. SQL is not engineering software performing intensive calculations, it just moves data around, so it will not benefit from 64bit word. On the other hand OS and SQLOS will consume more memory due to 8 bytes 'rounding'

Regards,

bbrown

Slawek Guzek wrote:

David Singleton wrote:

Upgrade the OS to 64bit. I don't think you can even install 64bit SQL on a 32 bit OS.

SQL is 32 bit and will stay 32 bit, so question is 32 or 64bit OS.

Even if SQL could be updated to 64 bit updating both SQL and OS to 64bit with only 4 GB of total RAM in machine makes no sense. SQL is not engineering software performing intensive calculations, it just moves data around, so it will not benefit from 64bit word. On the other hand OS and SQLOS will consume more memory due to 8 bytes 'rounding'

Regards,

huh? There are siginificant advantages to the 64 bit version of SQL.

Slawek_Guzek

bbrown wrote:

huh? There are siginificant advantages to the 64 bit version of SQL.

Significant advantage is only one. Increased address space. But this doesn't count if machine has only 4 GB of RAM.

bbrown

Slawek Guzek wrote:

bbrown wrote:

huh? There are siginificant advantages to the 64 bit version of SQL.

Significant advantage is only one. Increased address space. But this doesn't count if machine has only 4 GB of RAM.

The 4 GB limit is only because the system is running 32 bit Windows. If it was running 64 bit SQL logic says it would also be running 64 bit Windows which makes the 4 GB limit go away. Unless of course the hardware is limited to only 4 GB.

That increased address space is not such a small advantage. It reduces or eliminates many of the limitations on 32 bit SQL.

David_Singleton

Slawek Guzek wrote:

David Singleton wrote:

Upgrade the OS to 64bit. I don't think you can even install 64bit SQL on a 32 bit OS.

SQL is 32 bit and will stay 32 bit, so question is 32 or 64bit OS.

Even if SQL could be updated to 64 bit updating both SQL and OS to 64bit with only 4 GB of total RAM in machine makes no sense. SQL is not engineering software performing intensive calculations, it just moves data around, so it will not benefit from 64bit word. On the other hand OS and SQLOS will consume more memory due to 8 bytes 'rounding'

Regards,

Sorry I miss read the initial post. I thought the OP wanted to try installing 64bit SQL on 32 bit Windows, which I am 99% sure is impossible.

The only correct answer here is to upgrade the OS to 64bit. Then install 64 bit SQL.

kriki

[Topic moved from 'NAV/Navision' forum to 'SQL General' forum]