Hi Perry
Note : I hope this won't get confusing as my name is also Perry!
Take this scenario...
2 node active/passive cluster - SQL 2008 R2 on Windows 2008 R2
All data, log, backup drives hosted on SAN as drives F: , G: , H: respectively
Each node has 2 x SSD in RAID 1 configured as T:
Have you tried making a mount point on F: targeting the LOCAL SSD drive T: ?
We are looking at this technique to get tempdb and ASPState hosted in local SSD in a clustered solution. As tempdb and ASPState are db's that don't require persistence across a failover it appears to work as does not prevent the cluster from working or having SQL service packs / cumulative updates applied.
I am getting feedback on other forums that this is unsupported configuration by MS but http://support.microsoft.com/kb/819546 seems to state that mount points ARE supported on these versions. I cannot make out any statement that says that local drives cannot be the targets of the mount points.
Any opinions, good or bad, would be appeciated.
Regards
Perry D.