View Single Post
chucker
 
Join Date: May 2004
Location: near Bremen, Germany
Send a message via ICQ to chucker Send a message via AIM to chucker Send a message via MSN to chucker Send a message via Yahoo to chucker Send a message via Skype™ to chucker 
2009-03-06, 02:51

I suppose you could always trick SQL Server by putting tempdb on a RAM drive?

*looks around*

In fact, that idea seems less far-fetched than I had thought: http://www.google.com/search?q=ram+drive+tempdb — I skimmed over some of those hits and they all seem like worthwhile reads.

Quote:
Originally Posted by Banana View Post
Thanks, BTW, for sharing your input with your external drive.
Well, my situation is somewhat similar. The main applications I use are Visual Studio and SQL Server Management Studio. The locally installed SQL Server is only for testing, so is only sample data on it, but I nonetheless easily run into I/O issues — it is clearly by far the greatest bottleneck.
  quote