We have been given a new Database server with SAN drives attached for storage. We will see the SAN as 4 separate drives on the server (D,E,F,G). Drives D and E will be a 7 disk array using RAID 5. F and G will be s separate 7 disk array using RAID 5 also.
My question is how best to configure our databases on these drives. I was thinking of splitting the systems db's, user db's, indexes and logs like this:
D: System DBs E: User DBs F: Indexes G: Logs
but i'm not sure if that is the best solution. I wanted to keep data and indexes separate as well as data and logs separate. I'm not sure if it makes sense to keep the system dbs on there own filegroup or not.
the disks are setup as LUN's and RAID 5 was presented as best practice by our SAN admin for these particular SAN's (DELL PowerVault MD1000). The OS will be Windows Server 2008.
The databases are specifically used for Data Warehousing. There are a couple of staging databases, an ODS database and a Multidimensional database as well for analytics. The main time of loading will be between the hours of 7-10 am with the rest of the day being pretty much static.
The basic architecture for file distribution is good. Consider creating an IO profile for the database server. Perfmon does a good job aof presenting useful figures. Use these figures to calculate IOPs required broken down into read\write. Can the underlying system cope with the required IOPS at an acceptable speed. Create a report and pass it on to your SAN admin