I'm building a new SQL Server 2008 box and was considering SSD as part of the solution. Here's my current hardware plan:
Intel Quad Core x2
Disk #1 = RAID1 SSD (Windows Server 2008 + SQL Server 2008)
Disk #2 = RAID10 => Data File
Disk #3 = RAID10 => Log File
Redundant Gigabit Ethernet network
Is this a worthwhile use of an SSD? I can't use them to store the entire DB.