SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Moore's Law


Moore's Law

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (280K reputation)SSC Guru (280K reputation)SSC Guru (280K reputation)SSC Guru (280K reputation)SSC Guru (280K reputation)SSC Guru (280K reputation)SSC Guru (280K reputation)SSC Guru (280K reputation)

Group: Administrators
Points: 280560 Visits: 19901
Comments posted to this topic are about the item Moore's Law

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Elliott Whitlow
Elliott Whitlow
SSC-Forever
SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)

Group: General Forum Members
Points: 49374 Visits: 5314
I don't know, multiple fast cores.. The only thing I find exciting is the number of cores.. Speeds have largely peeked..

CEWII
IceDread
IceDread
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1695 Visits: 1145
Clock speed.. is not that relevant any more, at least not as it was some years ago. You might have noticed that nothing has happened with the clock for a few years time now.

What is important is how the cpu performs during a variation of tests.

Edit: And yes, I find it interesting.
Luke L
Luke L
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16291 Visits: 6150
desktops, servers it's really all the same at this point. I buy what I can afford... the most Cores and speed for the money. I do take a look at the on chip memory structures as well, but that's really about it.

-Luke.

To help us help you read this

For better help with performance problems please read this
vliet
vliet
SSC Eights!
SSC Eights! (921 reputation)SSC Eights! (921 reputation)SSC Eights! (921 reputation)SSC Eights! (921 reputation)SSC Eights! (921 reputation)SSC Eights! (921 reputation)SSC Eights! (921 reputation)SSC Eights! (921 reputation)

Group: General Forum Members
Points: 921 Visits: 791
Every serious SQL task, wether it's OLTP or OLAP, has to deal with some nasty rotating plate along a tiny magnetic core: the hard disk! More memory solves this problem only partialy, and over the years hard disk access has become the bottle neck for SQL Server on many recent installations. Because the size of hard disks increases more rapidly than their speed, separate partitions for data and logs reside often on the same disks, making the access times even worse.

Whenever you replace the hardware for SQL Server, how often this action was triggered by the lack of processing power? On several instances, replacing the hard disk controler, adding some diks and reconfiguring them to a RAID 10 set could postpone server replacement for years. Add some extra memory for your ever growing database will also increase the size of the other caches, allowing SQL Server to cache more procedures and queries thereby decreasing the computational load on the processor even further.

Maybe some day Microsoft will add a 'back-up only' option to SQL Server that will allow you to keep your entire database with its transction log in memory; you'll still be able to restore it from your last full, differential and log back-ups but the disk access will not hamper your transactions any more. Then I will look for faster processors, more cores and a lot more memory in my SQL Server hardware!
rja.carnegie
rja.carnegie
Old Hand
Old Hand (323 reputation)Old Hand (323 reputation)Old Hand (323 reputation)Old Hand (323 reputation)Old Hand (323 reputation)Old Hand (323 reputation)Old Hand (323 reputation)Old Hand (323 reputation)

Group: General Forum Members
Points: 323 Visits: 169
I believe I am jaded about progress on the desktop because whenever we get faster hardware, we get slower software and the user experience is approximately the same. If you're a big gamer then I guess things still improve, and speech control will go mainstream one day (Vista has it as standard but they don't push it), and we'll have to use pronounceable variable names.

But you can't pick a processor and order a good system around it, either. System building is a technical specialism, and basically you have to wait for a vendor to build the system that you want. That may never include the cute new processor that you heard about.

So really, are you excited about the new system, versus the new processor?

On top of that, tuning a new computer to get the best out of it is hard work. It really spoils the enjoyment.

As for a whole new dimension of bugs to solve, I am ecstatic to leave that to Microsoft. In fact, the number of service pack fixes that say "This fixes a bug in parallelism" influences me strongly to not use parallelism in individual queries: there's got to be a bunch of bugs they didn't find yet. Anyway our servers have more users than there are processors, so the point of parallelism is? :-)
GSquared
GSquared
SSC Guru
SSC Guru (118K reputation)SSC Guru (118K reputation)SSC Guru (118K reputation)SSC Guru (118K reputation)SSC Guru (118K reputation)SSC Guru (118K reputation)SSC Guru (118K reputation)SSC Guru (118K reputation)

Group: General Forum Members
Points: 118599 Visits: 9730
My computer at home is primarily a gaming machine, and I build my own machines, so for that, I pay attention to the details, including the CPU specs.

For the servers, I pay attention if the hardware is in any way my responsibility, which it currently is not.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
jeff.stanlick
jeff.stanlick
SSC Veteran
SSC Veteran (286 reputation)SSC Veteran (286 reputation)SSC Veteran (286 reputation)SSC Veteran (286 reputation)SSC Veteran (286 reputation)SSC Veteran (286 reputation)SSC Veteran (286 reputation)SSC Veteran (286 reputation)

Group: General Forum Members
Points: 286 Visits: 250
Our environment is going to more and more virtual servers connected to our SAN. So, I find myself more concerned with VMWare's limitations on CPU cycles, memory allocation and the SAN's access speeds. And to be honest, the only time I concern myself with CPU is when we're processing a cube or when someone misconfigured the thread count on a Red Gate backup as the database engine itself rarely pushes the CPU utilization.

-Jeff
Chris Harshman
Chris Harshman
SSCoach
SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)

Group: General Forum Members
Points: 19751 Visits: 5507
As others have said, the CPU seldom is the bottleneck in a database server. The only interesting thing to me about newwer processors is the tendancy toward more efficiency. Performance per Watt will determine long term costs. The number of cores and gigahertz just aren't a determining factor for a database server unless it's on a shared machine that is also doing other processing.

I/O and disk configuration are the real problems. I can't tell you how many times I've seen other people setup database servers with just a single RAID 5 array and say "now all reads and writes will be load balanced across all the disks!" and I just smack my forehead. The disk heads will be jumping back and forth constantly between TempDB, transaction log, data pages, index pages, etc, and will bog down disk I/O and thus your database. If your disk setup is bad, or network setup is bad, all those CPU cores will be twiddling their thumbs waiting for something to do.
jay-h
jay-h
SSCertifiable
SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)

Group: General Forum Members
Points: 6679 Visits: 2492
ho hum.

Certainly there is an interest in getting a fast new processor, but other than performance levels, it does not really change my job any. You deal with a slow processor just the same as you deal with a fast one.

...

-- FORTRAN manual for Xerox Computers --
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search