January 18, 2012 at 4:30 am
Hi,
Total 600 GB HD, and configured RAID 5 in OLTP SQL server 2008 R2, C drive 80, D drive 520 GB
As per these disk configuration, could anyone suggestion me where should placed Data, Tlog ,TempDB files on same D drive? or I will ask to server team to create another patition as below,
D drive - Data
E drive - Tlog
F drive - Tempdb
Thanks
ananda
January 18, 2012 at 4:52 am
ananda.murugesan (1/18/2012)
Hi,Total 600 GB HD, and configured RAID 5 in OLTP SQL server 2008 R2, C drive 80, D drive 520 GB
As per these disk configuration, could anyone suggestion me where should placed Data, Tlog ,TempDB files on same D drive? or I will ask to server team to create another patition as below,
D drive - Data
E drive - Tlog
F drive - Tempdb
Thanks
ananda
You could increase performance placing data, log and tempdb on different disks, but if it's the same disk array, it doesn't make any difference.
-- Gianluca Sartori
January 18, 2012 at 5:39 am
Thanks for your reply...
As per server array configuration one, there is no two different array controller.
Arrary Name - Smart array P400 in Slot1
Total 4 HD connected to the same array P400. so there is no performance getting same array, Even create D drive - data, E drive -Tlog, F drive - TempDB.
In this case will create 3 disk partion as below
C drive for OS
D drive for Data, Tempdb and Tlog
E drive for backup purpose.
thanks
ananda
February 6, 2012 at 9:04 pm
In this case since it's all coming from the same array, same HBA, then you won't see a performance increase. However from a manageability standpoint it's nice to have these files isolated to individual logical drives.
Also, side note but RAID 5 is good for a read heavy environment but your writes will be slower so take that into consideration.
Cheers!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply