February 1, 2010 at 10:58 am
Hi,
We are planning to Upgrade from SQL Server 2005 32 bit developer edition with SP3 to SQL Server 2005 64 bit developer edition. I need write the recommendation to the management about the benefits of this migration. I did find only the Memory usage benefit and other than that I did not find any benefits so far. So please advcie me what are the other benefits, I can put together.
Thanks
February 1, 2010 at 11:37 am
The benefits of 64 bit are that you can access more memory and have larger caches without penalties of swapping data around in memory (with AWE/PAE)
There is no upgrade. Essentially you will installing a new SQL Server instance and migrating things over.
February 1, 2010 at 1:12 pm
64 bit is best for consolidation projects where you plan on putting lots of DB's and/or SQL instances on one server to save licensing costs. If that doesn't make sense, then maybe it's not the best choice for you.
Maybe your development server is memory-strapped, in which case the upgrade would be well-advised to save licensing costs of spinning up a new server. DE is pretty cheap, though... I gues Windows licensing costs would factor in and new equipment costs.
You should also examine your current infrastructure and see that your buffer cache hit ratio is in the high 90% range and your page life expectancy is high (like 5 min + is very good). If that's the case, you might not need more memory on your current system and a rip & replace migration to 64 bit would be lots of work for not much immediate benefit.
Cheers!
Craig Outcalt
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply