May 25, 2004 at 11:09 am
I have a brand new server - Dell 4cpu, Windows 2003 standard with one raid 10 disk. The server is set up with a c drive (primary partition with 8 gig available) and and a d: drive (Logical drive with 128 gig available). From everything I have read, one performance recomendation is to split the log file and the data file onto seperate "disks". Does this mean seperate disk arrays? or In my case would the c: drive and d: drive count as seperate "disks".
This is going to be our database server for many years so I want to make sure we get this right. Any other recomendations are welcome.
Thanks
May 25, 2004 at 5:32 pm
It's preferable that they go on physically separate disk arrays, on a separate channel or even better, a separate controller. Logical partitioning really does nothing in terms of performance or recoverability.
If your equipment allows for it, a suggested setup could be:
c: drive - OS and SQL executables - (RAID 1)
l: drive - database logs - (RAID 10)
m: drive - main database data - (RAID 10)
n: drive - secondary db data - (RAID 10). Could be used for index filegroups if you really have just one primary database that gets hammered. Or other databases if you have more than one high-usage database and you'd like to separate them. Or, simply for database backups (if JUST for database backups then I suggest saving on disks and using RAID 5)
t: drive - tempdb - (RAID 0)
Cheers,
- Mark
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply