<div>
<div class="content wysiwyg-content">
I am running SQL6.5 and understand that you can put the TempDB in RAM to speed up performance. &nbsp;Can anyone tell me if this does make a difference and how do you go about doing this?
</div>
</div>


I am running SQL6.5 and understand that you can put the TempDB in RAM to speed up performance.  Can anyone tell me if this does make a difference and how do you go about doing this?

TempDB in RAM

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.