?
Solved

TempDB in RAM

Posted on 2000-01-31
1
Medium Priority
?
313 Views
Last Modified: 2012-05-04
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?
0
Comment
Question by:Sanmarco
1 Comment
 
LVL 9

Accepted Solution

by:
david_levine earned 150 total points
ID: 2463681
Here's a link to a document on when to use tempdb in RAM...

http://support.microsoft.com/support/kb/articles/Q115/0/50.asp?LNG=ENG&SA=TECH

Here's a link to a document that describes how to do it. It's for moving to a different device, but it goes into RAM as the intermediate step...

http://support.microsoft.com/support/kb/articles/Q187/8/24.ASP?LNG=ENG&SA=TECH
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

601 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question