SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

scabral7
Yak Posting Veteran

57 Posts

Posted - 04/03/2012 :  14:32:14  Show Profile  Reply with Quote
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 - 04/03/2012 :  15:15:26  Show Profile  Reply with Quote
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
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

scabral7
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

Sachin.Nand
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

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2076 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
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New 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.06 seconds. Powered By: Snitz Forums 2000