asked on
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.
Microsoft SQL ServerMicrosoft SharePoint
Last Comment
kathryntg
Straight from the horse's (Microsoft) mouth: http://support.microsoft.c
ASKER
Thanks for your response. Yes, I saw the article which helped me move in this direction. What I don't have, and can't find, is any implementation information. The only real-work examples I've found rely on modifying the config.sys, Is this still valid for Windows 2003 64bit? Does this require third-party software?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Although we did not implement RAM Disk; piercove's link provided the most complete information as to implementation. THanks