Can solid state drives be used for the TempDB on a SQL Server failover cluster if they are local drive on both machines? It is supported in 2012 but our cluster is a SQL 2005. The application that it is running isn’t upgradeable to 2012.
If the SSD drives are on the same local path on both servers wouldn't it just rebuilt the TempDB when it failed over? Wouldn't the cluster recognize any drive the OS recognizes? Or are there other issues that need to be accounted for.
I realize that Microsoft won’t support it but the performance gain would be great. Our TempDB on that cluster is the heaviest used DB and we can’t change any code in the application it runs.