Una dettagliata lista a molti whitepaper e risorse della KB di Microsoft dedicate allo storage engine:

http://blogs.msdn.com/psssql/archive/2006/11/27/what-do-i-need-to-know-about-sql-server-database-engine-i-o.aspx