Microsoft SQL Server Performance Top Tip: Multi Processor (SMP) sudden death syndrome.

re: SQL Server Performance Top Tip: Multi Processor (SMP) sudden death syndrome.

Mike Dimmick — Wed, 02 Feb 2005 22:13:00 GMT

I was going to ask what happens when the database runs out of file space, but then I suppose in a large system with SMP you would have one file per logical disk, which you'd make the size of the disk.

Automatic growth is really only for development and test, I suppose. In production you need to monitor how full the files are and plan for additional disks when getting close to capacity. I'm not sure it's even possible to add an additional stripe to an existing striped set.

At my employer, a small ISV/VAR, we don't see a lot of serious enterprise hardware. At least, the developers don't get to see it - some of our customers have it. The nearest we've got lately are some HP ProLiant DL380 G4 boxes set up with three disks in a RAID-5 configuration. It sounds like that customer might well run into the problem you describe, although the _first_ thing they'll need to do is put different databases on different spindles and the transaction logs on different spindles again.

Today is one of those I days I miss Take Outs.

Enjoy Every Sandwich — Thu, 03 Feb 2005 09:26:00 GMT

Today is one of those I days I miss Take Outs.

re: SQL Server Performance Top Tip: Multi Processor (SMP) sudden death syndrome.

Patrick Wellink — Thu, 03 Feb 2005 15:14:00 GMT

We had a situation like this.... and one processor would be up to 100% all the time....

It became clear that paralel execution of the query caused the problem. It would give a TempDB error message and from then on the thread would push the processor to 100 %

after disabeling paralel execution (setting query cost to 99999) plans this problem has gone away as wel as the tempDB errors.....

re: SQL Server Performance Top Tip: Multi Processor (SMP) sudden death syndrome.

Matthew Stephen — Fri, 04 Feb 2005 18:21:00 GMT

Automatic growth is also good for low Maintenance databases - typically MSDE applications that only run with one processor

re: SQL Server Performance Top Tip: Multi Processor (SMP) sudden death syndrome.

Matthew Stephen — Fri, 04 Feb 2005 18:22:00 GMT

Parallelism - I'll post a blog on this sometime soon

AutoGrow Apparently Means “I Don’t Care” | SQLRockstar

AutoGrow Apparently Means “I Don’t Care” | SQLRockstar — Wed, 27 May 2009 20:13:51 GMT

PingBack from http://thomaslarock.com/2009/05/autogrow-apparently-means-i-dont-care/