This presentation will give you very useful and higly technical information about SQL Server 2005 and 2008 High Availability features.
You will see also very recent benchmarks results:
- SQL Server mirroring on SQL Server 2005 vs. 2008
- SQL Server database hosted on Conventional disks vs. Solid State Devices
View more PDF documents from Thierry Gerardin.