Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Moore's Law


Moore's Law

Author
Message
Steve Jones
Steve Jones
SSC-Forever
SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)

Group: Administrators
Points: 42110 Visits: 18876
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
SSCertifiable
SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)

Group: General Forum Members
Points: 7236 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
Old Hand
Old Hand (363 reputation)Old Hand (363 reputation)Old Hand (363 reputation)Old Hand (363 reputation)Old Hand (363 reputation)Old Hand (363 reputation)Old Hand (363 reputation)Old Hand (363 reputation)

Group: General Forum Members
Points: 363 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
SSCrazy
SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)

Group: General Forum Members
Points: 2984 Visits: 6120
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-Enthusiastic
SSC-Enthusiastic (126 reputation)SSC-Enthusiastic (126 reputation)SSC-Enthusiastic (126 reputation)SSC-Enthusiastic (126 reputation)SSC-Enthusiastic (126 reputation)SSC-Enthusiastic (126 reputation)SSC-Enthusiastic (126 reputation)SSC-Enthusiastic (126 reputation)

Group: General Forum Members
Points: 126 Visits: 752
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
SSC-Enthusiastic
SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)

Group: General Forum Members
Points: 101 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
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: 16681 Visits: 9729
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 (272 reputation)SSC Veteran (272 reputation)SSC Veteran (272 reputation)SSC Veteran (272 reputation)SSC Veteran (272 reputation)SSC Veteran (272 reputation)SSC Veteran (272 reputation)SSC Veteran (272 reputation)

Group: General Forum Members
Points: 272 Visits: 244
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
Hall of Fame
Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)

Group: General Forum Members
Points: 3277 Visits: 3538
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
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1165 Visits: 2257
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