Does SQL 7 support tempdb in ram?

A. No, this support has been removed.

There is nothing stopping you using an NT level ramdrive - several exist - and put tempdb on that. However in almost all cases you are better off just letting SQL have the extra memory for caching.


Hide comments

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.
Publish