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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Database File Configurations

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 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?

thanks
Scott

X002548
Not Just a Number

15586 Posts

Posted - 2012-04-03 : 15:15:26
Sounds ok to me

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/


Go to Top of Page

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 ....
Go to Top of Page

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.
Go to Top of Page

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 ....
Go to Top of Page

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 admin

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -