2000 32Bit to 2005 64Bit - Need advice!

Last Post 21 Sep 2007 06:45 AM by Jeff Armstrong. 2 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
phil.wade
New Member
New Member

--
22 Jul 2007 10:48 PM
Hi All

I am looking to conslidate some of our larger and more heavly used production databases to SQL 2005 64Bit. However in order to do this I am trying to finde some information or links on the benefits of this move.

If anyone can assist me with this I would be mose grateful.

Many Thanks

Phil
SQLUSA
New Member
New Member

--
10 Aug 2007 10:54 PM
Generally more memory is helpful due to page caching which will decrease io contention.

Merging several heavily used databases onto one server invites some deep concern.

One way to compensate is MORE & FASTER of everything. Memory, cpu-s, disk controllers, etc.

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQLUSA: http://www.sqlusa.com/order2005grandslam/ - The Best SQL Server 2005 Training
Jeff Armstrong
New Member
New Member

--
21 Sep 2007 06:45 AM
Is there a reason why you would go with SQL 2005 Enterprise Edition? The Standard Edition has all the benefits of using unlimited memory (as much as your OS will allow). From what I understand, performance does not increase from SE to EE. The difference is more features are available in EE such as mirroring and table partitioning among others.


Acceptable Use Policy
---