Re: tempdb mdf and ldf placement

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Ron Talmage (rtalmage_at_prospice.com)
Date: 12/12/04 

Date: Sat, 11 Dec 2004 17:01:55 -0800

Kelly,

Usually tempdb does not benefit from separating the MDF from LDF because
tempdb does not use the transaction log quite as much as other databases.
You need to test it.

Ron 

-- 
Ron Talmage
SQL Server MVP
"Kelly F." <anonymous@discussions.microsoft.com> wrote in message
news:2d8301c4def6$ba9d2b40$a301280a@phx.gbl...
> I believe tempdb should be on its own set of hard drives,
> meaning not with other sqlserver.exe and not with the MDF
> or LDF files from user or system databases.  Since it
> remains in simple recovery mode, is it important to split
> the tempdb MDF and LDF to separate hard drives or can they
> be on the same hard drive (raid array) together?
>
> Kelly
Quantcast