TempDB

Last Post 16 Mar 2008 06:32 PM by SQLUSA. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
river1
New Member
New Member

--
16 Mar 2008 05:12 PM
Hi-

I have dificulties in understanding why TempDB should be in a separeted RAID.
I have a TempDB, but this tempDB is not used by temporary tables (#table1 or ##table1).
I have to create a production server an i read in all places that a tempDB should be in a
separated RAID, for best performance.
Can someone expliain me why? or give me a link sow i can read about it?

Tks,

Pedro
SQLUSA
New Member
New Member

--
16 Mar 2008 06:32 PM
Pedro,

The movement of disk read-write heads makes it the slowest part of a computer system.

Even if you don't use #temptables, the system is using the tempdb for indexing, sorting, snapshot isolation and more.... So you want to add more read/write heads.... to keep the system humming...

That is the reason that you should have for high performance:

1. Tran log on dedicated RAID 1 (or 10)
2. Tempdb on dedicated RAID 1 (or 10)
3. Frequently used indexes on dedicated RAID 1 ( or 10)
4. Data on dedicated RAID 5 (or 10)

Kalman Toth
SQL Server 2005 Performance Tuning Training - http://www.sqlusa.com/order2005highperformance/

river1
New Member
New Member

--
16 Mar 2008 06:47 PM
tks, kalman

About data files(4), i think that you meen RAID 5 or RAID 50 instead of RAID 5 or RAID 10.

Another question that i have is about raids:

DELL told me that raid 5 is faster for reads that raid 1, but i read in sites that rai5 is not better that raid 1 in anything not even in reads.

What do you think about this?


Tks,

Pedro
You are not authorized to post a reply.

Acceptable Use Policy