November 23, 2011 at 7:43 am
Hi All,
Server Structure:
Sql Server 2008 R2
C: SCSI Drive (Server's Drive)
D: SATA
E: SATA
F: SATA
The Temp DB is on C: as it is faster than the SATA drives. On the other hand putting tempDB in windows drive is also not advisable.
Can anybody suggest whether moving tempDB from SCSI drive to SATA will improve the performance as it won't be the window's drive.
Thanks,
swaroop
November 23, 2011 at 7:57 am
It depends on the SATA generation, the SCSI version, how many I/O channels (drives, etc.) on each, the bus each is connected to on the motherboard, the buffer and I/O rate of the drives involved, and the buffer and configuration and hardware on any drive controller.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply