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 (84K reputation)SSC Guru (84K reputation)SSC Guru (84K reputation)SSC Guru (84K reputation)SSC Guru (84K reputation)SSC Guru (84K reputation)SSC Guru (84K reputation)SSC Guru (84K reputation)

Group: Administrators
Points: 84221 Visits: 19223
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
SSChampion
SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)

Group: General Forum Members
Points: 13170 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
SSChasing Mays
SSChasing Mays (645 reputation)SSChasing Mays (645 reputation)SSChasing Mays (645 reputation)SSChasing Mays (645 reputation)SSChasing Mays (645 reputation)SSChasing Mays (645 reputation)SSChasing Mays (645 reputation)SSChasing Mays (645 reputation)

Group: General Forum Members
Points: 645 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
SSCarpal Tunnel
SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)

Group: General Forum Members
Points: 4925 Visits: 6136
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 Veteran
SSC Veteran (294 reputation)SSC Veteran (294 reputation)SSC Veteran (294 reputation)SSC Veteran (294 reputation)SSC Veteran (294 reputation)SSC Veteran (294 reputation)SSC Veteran (294 reputation)SSC Veteran (294 reputation)

Group: General Forum Members
Points: 294 Visits: 767
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 (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)

Group: General Forum Members
Points: 149 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-Dedicated
SSC-Dedicated (31K reputation)SSC-Dedicated (31K reputation)SSC-Dedicated (31K reputation)SSC-Dedicated (31K reputation)SSC-Dedicated (31K reputation)SSC-Dedicated (31K reputation)SSC-Dedicated (31K reputation)SSC-Dedicated (31K reputation)

Group: General Forum Members
Points: 31167 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 (280 reputation)SSC Veteran (280 reputation)SSC Veteran (280 reputation)SSC Veteran (280 reputation)SSC Veteran (280 reputation)SSC Veteran (280 reputation)SSC Veteran (280 reputation)SSC Veteran (280 reputation)

Group: General Forum Members
Points: 280 Visits: 246
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
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: 6672 Visits: 4262
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
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2418 Visits: 2341
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