December 28, 2009 at 3:22 am
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
moonos
December 30, 2009 at 3:43 am
I'm really not sure it makes such a difference. Presumably you're just using this data set on a local machine for development work, after all. It's also an impossible question to answer without knowing what sort of access patterns this data will have--for example, I'd say that in most cases SQL server will be more constrained by disk space and available RAM than it is by the CPU.
December 30, 2009 at 6:01 am
Doesn't really matter much. Just get whatever you can afford. IO performance (not capacity!!) and RAM in the box will be MUCH more important than CPU type on any box less than a year or so old.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply