October 2010 - Posts

• Solid-State Storage

  After years of anticipation and false starts, the SSD is finally ready to take a feature role in database server storage. There were false starts because NAND flash is very different from hard disks and cannot be simply dropped into a storage device and Read More... Posted Monday, October 25, 2010 12:19 PM by jchang | 10 Comments Filed under: Storage, SSD

• IO Queue Depth Strategy

  I am finally getting around to setting up a SSD array, starting with a few, then working up to perhaps 20 units over 2 controllers and 4 x4 SAS ports. During initial testing I observed very high disk latency, in the range of 100ms+ for reads and upto Read More... Posted Monday, October 18, 2010 5:43 PM by jchang | 13 Comments Filed under: Storage

• Caching RAID Controller Performance Tuning Secrets (cough-giggle)

  Over weekend I was looking at various RAID controller documents to update my material on storage performance, and I came across three items that were good for a hoot. Direct IO, not Cached IO The LSI slidedeck MegaRAID Performance Tuning and Benchmark Read More... Posted Monday, October 11, 2010 9:07 PM by jchang | 8 Comments Filed under: Performance, Storage, RAID Controllers

• So when is Parallel SQL arriving? Denali?

  For some time, Intel C/C++ compilers addons had the ability to automaticly generate parallel code (as in the coder does not have to do it). I also recall hearing some thing about Parallel LINQ, but thats outside the scope of my narrow view of the world. Read More... Posted Monday, October 4, 2010 4:38 PM by jchang | 16 Comments Filed under: Parallelism