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
    Webmaster
    SQL-Server-Performance.Com

Share This Page