RAM Disk for TEMPdb to support MOSS SQL configuration
I am deploying a new enterprise-level MOSS environment. Due to $ constraints the SAN originally spec'd for the environment was axed and I'm stuck with local disks. The target audience is large enough that I need to optimize SQL as much as possible, which is going to hard to do with only 3 spindles on the SQL server. I have seen posts that recommend using RAM disk for the tempdb and TLogs but not much information as to the actual implementation. Before I spend huge amounts of time researching and then selling the concept to those who sign off on the architecture I'd like to hear form anyone who might be currently using RAM disk. Thanks for any thoughts or recommendations.