Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
scabral7
Yak Posting Veteran
57 Posts |
Posted - 2012-04-03 : 14:32:14
|
Hi,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 DBsE: User DBsF: IndexesG: Logsbut 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.Any ideas or best practices?thanksScott |
|
X002548
Not Just a Number
15586 Posts |
|
Sachin.Nand
2937 Posts |
Posted - 2012-04-04 : 02:59:42
|
First why are you using RAID 5 cause if your database is quite write intensive the performance will suffer.And the disks that you stated are they physical disk or LUN's?What about the OS ? where are you planning to put it ?After Monday and Tuesday even the calendar says W T F .... |
|
|
scabral7
Yak Posting Veteran
57 Posts |
Posted - 2012-04-06 : 09:48:25
|
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. |
|
|
Sachin.Nand
2937 Posts |
Posted - 2012-04-08 : 02:52:37
|
With that kind of environment I would say RAID 5 is a best choice but putting indexes and system db's on a different disk or a LUN would be a NO NO for me.It is pure wastage of disks.Are those LUN's dedicated only to SQL Server or are being shared by other applications as well ?After Monday and Tuesday even the calendar says W T F .... |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-04-09 : 04:30:27
|
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 adminJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|