Placing Filegroups on separate drives

Hi All,

I have adatabase which is over 150GB in size and an estimated size of 1 Terabyte. I am planning to split the database into various filegroups. I have already separated the indexes and data from the Database. My Tempdb is in separate physical drive.

I was thinking if it’s a good idea to place each filegroup into a separate drive. The drives are not physical drives but partitioned, however the drive I portioned is raid 1+0.

Would I get any great performance benefit of placing filegroups on their own drives ?

Placing the filegroup structure below.

No

Filegroup

Drive

1

PRIMARY

F

2

LOG

J

3

AD_Data

G

4

AD_Indexes

H

5

CV_Data

I

6

CV_Indexes

J

7

DIM_Data

K

8

DIM_Indexes

L

9

FACT_Data

M

10

FACT_Indexes

N

11

STAGING_Data

O

12

STAGING_Indexes

P

13

ORG_Data

Q

14

ORG_Indexes

R

15

TMP_Data

S

16

TMP_Indexes

T

Any help would be appreciated

Thx

It depends whether these drives have separate controllers or not. If so, then its possible that a query accessing data in separate files groups will use multiple contollers so the data can be access simultaneously giving better performance. If they all use the same controller then performance will be be helped. If one or more tend to grow more quickly they could be put on separate drives and auth growth paramters might be different but that really isn't peformance related unless auto growth occurs during an INSERT or UPDATE. It may be faster to autogrow one smaller filegroup than one huge database.

My 2 cents