Link to home
Start Free TrialLog in
Avatar of kathryntg
kathryntg

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.
Avatar of piercove
piercove
Flag of United States of America image

Straight from the horse's (Microsoft) mouth: http://support.microsoft.com/kb/115050/EN-US
 
Avatar of kathryntg
kathryntg

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
Avatar of piercove
piercove
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Although we did not implement RAM Disk; piercove's link provided the most complete information as to implementation.  THanks