Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Database File Configurations
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Yak Posting Veteran

57 Posts

Posted - 04/03/2012 :  14:32:14  Show Profile  Reply with Quote

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.

Any ideas or best practices?


Not Just a Number

15586 Posts

Posted - 04/03/2012 :  15:15:26  Show Profile  Reply with Quote
Sounds ok to me



Hint: Want your questions answered fast? Follow the direction in this link

Want to help yourself?

Go to Top of Page

Flowing Fount of Yak Knowledge

2937 Posts

Posted - 04/04/2012 :  02:59:42  Show Profile  Reply with Quote
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 ....
Go to Top of Page

Yak Posting Veteran

57 Posts

Posted - 04/06/2012 :  09:48:25  Show Profile  Reply with Quote
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.
Go to Top of Page

Flowing Fount of Yak Knowledge

2937 Posts

Posted - 04/08/2012 :  02:52:37  Show Profile  Reply with Quote
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 ....
Go to Top of Page

Flowing Fount of Yak Knowledge

United Kingdom
2179 Posts

Posted - 04/09/2012 :  04:30:27  Show Profile  Visit jackv's Homepage  Reply with Quote
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

Jack Vamvas
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000