|   | ![]() |
|
Should I use tempdb in ram? 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. |
All content on this site, except where noted, represents an original work of Michael R. Hotek and is protected by applicable copyright laws. The SQL Server FAQ is the sole work of Neil Pike. No page, portion of a page, or download may be used for commercial purposes in whole or in part without the express, written permission of the applicable author.