Re: tempdb mdf and ldf placement
From: Rick Sawtell (quickening_at_msn.com)
Date: 12/10/04
- Next message: Maury Markowitz: "What's the proper syntax for this?"
- Previous message: Bob Castleman: "Re: Random number"
- In reply to: Kelly F.: "tempdb mdf and ldf placement"
- Next in thread: Ron Talmage: "Re: tempdb mdf and ldf placement"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 10 Dec 2004 14:45:09 -0600
"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
It depends. <My favorite database answer>
The short answer is: Treat it like you would any other user database that
uses simple recovery mode.
The long answer is:
To really answer this question, you need to look at what tempdb is used for.
Primarily it is a working storage area for queries, reindexing and temp
tables. Depending on the size of your databases, the amount of and size of
your indexes and how large your queries are etc, should give you some
direction on how to handle the placement of the tempdb database.
If it has a LOT of activity, then a RAID 0 might be your best choice. Keep
in mind that tempdb is rebuilt every time SQL Server restarts. If there is
not a ton of activity and you have relatively small databases and indexes
etc., running it on a regular NTFS partition on your system partition (C:\)
may be appropriate. That of course depends on what else your O/S is doing
on that computer.
For moderate sized databases, I only see minor problems putting it on a RAID
5 controller. The extra time and loss of storage space required by RAID 5
for a database that is as dynamic as the tempdb may outweigh it's benefits.
Rick Sawtell
MCT, MCSD, MCDBA
- Next message: Maury Markowitz: "What's the proper syntax for this?"
- Previous message: Bob Castleman: "Re: Random number"
- In reply to: Kelly F.: "tempdb mdf and ldf placement"
- Next in thread: Ron Talmage: "Re: tempdb mdf and ldf placement"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
