SQL Server Performance

Tempdb located on local disk

Discussion in 'SQL Server Clustering' started by bmorley73, Apr 20, 2005.

  1. bmorley73 New Member

    We're running a clustered SQL Server on Windows 2003 (64bit) environment, and I was wondering if it possible to 'spoof' SQL server to use a local disk(i.e RAMDisk) rather than a SAN disk for tempdb datafiles to improve performance.
  2. Argyle New Member

    Not possible that I'm aware of. And even if it was it would not be a supported solution <img src='/community/emoticons/emotion-4.gif' alt=':p' />
  3. bradmcgehee New Member

    Argyle is correct, there is no supported way of doing this. Instead, try to avoid using the temp table as much as possible.

    Brad M. McGehee, MVP

Share This Page