You can go down sector sizes but you can't go up.

If your storage is a 4k sector you cannot restore a database that is a 512 byte sector to it.

You...

Ray Laubert,

If you have multiple log files on a single drive that effectively makes it random I/O and a good candidate for solid state. If, however you have dedicated spindles...

ryabel,

When this article was written FusionIO was pretty much the main player in the enterprise space. I have covered several of the topics you are looking for on my blog...

I would say this is a known error in 2008. Is the plan making use of any temporary objects at all? An eager spooler for example?

I prefer to use a two column approach to build a tree instead of the single column style that you have to split, it doesn't scale well. For smaller stuff...

you have to use a trace flag to enable mounting database files on a network share. It isn't recommended at all. http://support.microsoft.com/kb/304261

Gail didn't post an opinion. Her conclusion is based on fact.

Having build backup tools and log readers for a living she is 100% correct. You have gone as far...

if you set the size of tempdb it will default to that size on restart. It doesn't report the sizes properly in 2008 in some parts of the GUI you...

I'd seriously think about calling MS support on this one.

run dbcc on master.

Check to make sure that nothing else is trying to access the database files process monitor from sysinternals will tell you 100% who is accessing the files.

Check...

Paul White NZ (4/11/2010)

---

Well that is true to some...

brett.hawton (4/9/2010)

---

Great article!

Just some personal observations:

1. On larger queries SQL Server read-ahead kicks in and it reads 512KB blocks at a time. In my observations disks are much better at...

Get a quote for 5TB on the dsi3600 or a comparable TSM RAM-SAN. 8 Fusion-IO 640 Duo's get you 5.1TB of raw space. will retail at 124k. another 10k for...

ian-707364 (4/9/2010)

---

This is the reply I received from my contact at Fusion IO

"The sector size can be changed between 512(default) and 4k (4096) (not 8k). I think this is only...

With the INTEL drives did you have the same memory overhead as what is described by Wes in this article?

I'm trying to determine the scope of this additional memory requirement....