Should I use tempdb in ram?

Neil Pike

March 4, 1999

1 Min Read
ITPro Today logo in a gray background | ITPro Today

A. The short answer is no. In almost all cases you are better offjust 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.

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like