Subscribe to this blog
SQL Man of Mystery
Archives: December 2009
Fundamentals of Storage Systems – RAID and Hard Disk Reliability, Under the Covers
In the last RAID article we covered the basics. This is a little deeper dive into the underlying mechanics of RAID. Exactly what it does, how it does it and what it doesn’t do that people assume it does. I sited David Patterson, Garth Gibson, and Randy Kats and their… Read more
4 comments, 440 reads
Posted in SQL Man of Mystery on 8 December 2009
Fundamentals of Storage Systems – RAID, An Introduction
In previous articles, we have covered the system bus, host bus adapters, and disk drives. Now we will move up the food chain at take a look at getting several disks to operate as one.
In 1988 David A. Patterson, Garth Gibson, and Randy H. Katz authored a seminal paper,… Read more
21 comments, 2,149 reads
Posted in SQL Man of Mystery on 7 December 2009
Fundamentals of Storage Systems – Disk Controllers, Host Bus Adapters, and Interfaces
We have covered the Hard Disk and the System Bus. This time around we will cover disk controllers and host bus adapters.
In The Beginning…
There were three distinct components to your IO subsystem, the disk, controller, and the host bus adapter. Today there are still three distinct components but… Read more
2 comments, 1,445 reads
Posted in SQL Man of Mystery on 3 December 2009
Fundamentals of Storage Systems – Testing IO Systems
12/03/2009 - UPDATE! There were a couple of bugs in the SQLIOCommandGenerator new SQLIOTools.zip has been updated.
------------------------------------
I often tell people one of the greatest things about SQL Server is that anyone can install it. I also tell people what the worst things about SQL Server is that anyone… Read more
4 comments, 444 reads
Posted in SQL Man of Mystery on 2 December 2009