cancel
Showing results for 
Search instead for 
Did you mean: 

CPU comparison

Community Veteran
Posts: 3,274
Thanks: 339
Fixes: 12
Registered: 24-10-2013

CPU comparison

so what's better, clock speed or cpu model

Pentium Dual-Core E5800 @ 3.2GHz (https://ark.intel.com/products/42802/Intel-Pentium-Processor-E5800-2M-Cache-3_20-GHz-800-MHz-FSB)
or
Intel Core 2 Duo E6550 @ 2.33Mhz (http://ark.intel.com/products/30783/Intel-Core2-Duo-Processor-E6550-4M-Cache-2_33-GHz-1333-MHz-FSB)

both running windows 7 64 bit wiht 4GM RAM.
obviously the Core 2 Duo is newer, but has a slower clock speed.
does the newer technology trump the drop in clock speed?

20 REPLIES
Community Veteran
Posts: 4,987
Thanks: 1,154
Fixes: 29
Registered: 16-10-2014

Re: CPU comparison

Ideally it's all down to instructions per second, the higher the GHz the more instructions the CPU can execute. However, you also need to take in to consideration the work being done on the CPU and where the data for it lives. If its all local and in one of the caches (L1, L2) then that's good, but if it's been paged out during a context switch then that's not good.

Community Veteran
Posts: 3,274
Thanks: 339
Fixes: 12
Registered: 24-10-2013

Re: CPU comparison

majority of the tasks will be via SQL Management Studio installed locally running queries etc on a local SQL server.
other than that, just the usual work environment stuff.
SpendLessTime
Aspiring Hero
Posts: 2,376
Thanks: 585
Fixes: 53
Registered: 21-09-2009

Re: CPU comparison

@chenks76

A good site to check CPU speeds relative to one another is https://www.cpubenchmark.net/

Community Veteran
Posts: 3,274
Thanks: 339
Fixes: 12
Registered: 24-10-2013

Re: CPU comparison

i've often found those cpu benchmark ratings are mostly meaningless, as they don't really take into account real life useage.

however..

Untitled.png

Community Veteran
Posts: 4,987
Thanks: 1,154
Fixes: 29
Registered: 16-10-2014

Re: CPU comparison

@chenks76 - Well for one if you’re running a local install of SQL server then ideally you’d want a quad core variant of these CPUs or similar, to give you some semblance of performance. SQL Server is greedy for resources and CPU hungry and ideally should be run on dedicated hardware, but I appreciate that’s not an option for everyone.

Having said that if your database, indices and queries are optimised it shouldn't be too bad (FLW). Out of curiosity have you considered using PostgreSQL at all?

Community Veteran
Posts: 3,274
Thanks: 339
Fixes: 12
Registered: 24-10-2013

Re: CPU comparison

no, it's not a local installed SQL server, it's just the management tool to manage an SQL server that is on the local network.
Community Veteran
Posts: 4,987
Thanks: 1,154
Fixes: 29
Registered: 16-10-2014

Re: CPU comparison

Even better @chenks76, but I'd still go for a quad core CPU, they can be had for the same price ±

Community Veteran
Posts: 3,274
Thanks: 339
Fixes: 12
Registered: 24-10-2013

Re: CPU comparison

it's a choice between the two listed, as those are the two base units currently sitting here.
SpendLessTime
Aspiring Hero
Posts: 2,376
Thanks: 585
Fixes: 53
Registered: 21-09-2009

Re: CPU comparison

If the machines are similar (memory, network cards) then I would go with the E5800 (as it is the faster of the 2)

Community Veteran
Posts: 3,274
Thanks: 339
Fixes: 12
Registered: 24-10-2013

Re: CPU comparison

yeah the only difference is the CPU.
Community Veteran
Posts: 4,987
Thanks: 1,154
Fixes: 29
Registered: 16-10-2014

Re: CPU comparison

Ah! Sorry @chenks76, I got that one wrong. I thought you were looking to buy a processor to run the aforementioned hardware.

Community Veteran
Posts: 3,274
Thanks: 339
Fixes: 12
Registered: 24-10-2013

Re: CPU comparison

so clock speed wins even though it's an older generation CPU ?
wisty
Aspiring Pro
Posts: 443
Thanks: 54
Fixes: 3
Registered: 30-07-2007

Re: CPU comparison

Then to some extent it depends what you plan to do with the other one.

I suspect for the purpose you describe the system will spend the vast majority of its time sitting there idle, and the difference in performance between the two will be very small in real life.

If you have a heavy compute role for the second server then take the slower one for your management station. Otherwise I don't think you will be able to notice the difference.

Community Veteran
Posts: 3,274
Thanks: 339
Fixes: 12
Registered: 24-10-2013

Re: CPU comparison

oh it will never be sitting idle.
it'll be used all the time during working hours.

also, neither are servers! these are both desktops. i never suggested either of them would be a server.