Don't forget that while you might have the panels to power your house, the power is only there part of the day. You need a storage system of some sorts,...

I think LINQ -> SQL gets more play overall. At some of the developer presentations I've seen, it's always the highlight and gets most of the time. The people up...

There is only one tempdb. You can use multiple files, which could potentially provide advantages if there are separate physical devices under each.

John,

Those sound like very interesting projects. Are they written up anywhere? You want to write an update for me sometime ;)?

The greenness of technologies is always an issue. I've heard...

Since the log writes must complete before the database writes, if the log is slow, it can slow everything.

If nothing changed on the disks, I'm not sure of the issue....

Correct on sockets. If you virtualize, you also only need to license all physical sockets, not cores or virtual CPUs.

Maybe I'm missing something, but if I understand, the Unix box writes to the SQL instance on a remote Windows box.

Therefore you have 3 places where there could be bottlenecks.

1....

You're welcome and good to hear it works in places.

The idea that executives shouldn't be in charge of their machines is probably a good one. If nothing else, they probably...

Good comments and I'll be sure this thread gets to the LINQ guys in Redmond.

Apologies on the acronym. I've heard so much about this over the last 6 months...

I'm not sure about the parameters off the top of my head, but it looks like you've got capability the 13MB.sec is a little disconcerting.

How about writing from the source...

It's hard to know what an average is. Big disks are cheap, but putting disks into a SAN, running SCSI-x is more expensive, moving to RAID, etc. It adds up....

The 2008 compression algorithm seems very good, however it's an Enterprise-Edition only feature. If that works for you, great, but if not, check out the other products.

Is this running under SQLAgent?

If so, can you set a job to run xp_cmdshell 'dir > c:/test.txt'

and see what the free space is reported?'

That's if the Red Gate thing...

Doh!!!

Fixed.

Red Gate has SQL Doc( I work for them)

ApexSQL has something as well.