Skip navigation

Should I use tempdb in ram?

A. The short answer is no. In almost all cases you are better off just letting SQL have the extra memory for caching.

Support for tempdb in ram has been removed in SQL 7.

As an alternative, there is nothing stopping you using an NT level ramdrive - several exist - and put tempdb on that.

TAGS: SQL Server
Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.