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.
0 comments
Hide comments