April 22, 2007 at 9:36 am
Is it possible to install 32-bit SQL Server 2005 on 64-bit Windows 2003 Server? Are there any significant disadvantages of doing so?
Thanks,
Del piero
April 23, 2007 at 5:24 am
Yes, you can install the 32-bit version of SQL Server on a Windows 64-bit OS. The differences are the 32bit/64bit differences.
April 23, 2007 at 6:44 am
Yes, it's possible and I did that at my previous job. We had x64 AMD opteron box that I installed Windows Server 2003 Standard 64 bit OS. Applied SP1 at the time and all the patches. Then SQL Server 2000 Standard Edition 32 bit and applied SP4. SQL server 32 bit runs on WOW on a 64 bit OS. But runs just fine and we did not have any issues. And it was very fast.
Good day,
Bulent
April 23, 2007 at 8:37 am
The most significant disadvantage is that 32-bit SQL Server will not be able use as much memory. This may not be an issue if your server has 4GB or less to begin with. If you give a 32-bit system more ram through AWE it will use it for buffer pool, while other memory pools such as procedure cache remain fixed and can be a bottleneck. All pools are more flexible in 64-bit and will grow or shrink based on the memory pressure in each pool.
Yes, 32-bit SQL Server will run on a 64-bit system. But probably not as well as 64-bit SQL, especially if the system has extra RAM going to waste. On the other hand, if you have some 64-bit compatability issue with third-party drivers or software you may have no choice. Then the question becomes whether that software will run on WOW.
April 23, 2007 at 7:28 pm
Thanks all!
April 24, 2007 at 6:12 am
we have 32 bit running on 64 bit windows. We are having trouble with SSIS, but the database engine works great.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply