Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 Intel or AMD CPU for SQL Server 2005

Author  Topic 

thebrowngrowler
Starting Member

4 Posts

Posted - 2009-12-28 : 05:09:51
Hi,

Would anyone please be able to advise me on the best CPU type to use with a local installation of SQL Server 2005 Developers Edition ?

For example, do I need a 4 core CPU or will a 2 core CPU be OK for maximum efficiency, ie, does the local Developers Edition use all 4 cores / 2 cores or not etc. Also, is there any impact from threading and cache size on the CPU ?

The general view I have picked up from reading is that Intel CPU's would probably be better, however, what characteristics give Intel the advantage over AMD. If Intel are best, which Intel CPU would be best for a local installation of SQL Server 2005 Developers Edition ?

The data sets that the installation works with are up to 3 million records with approximately 20 fields per record.

Thx
Growlos
   

- Advertisement -