Placing Filegroups on separate drives

hi all,

i have a  database on 150gb in size , estimated size of 1 terabyte. planning split database various filegroups. have separated indexes , data database. tempdb in separate physical drive.

i thinking if it’s idea place each filegroup separate drive. drives not physical drives partitioned, drive portioned raid 1+0.

would great performance benefit of placing filegroups on own drives ?

placing 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 appreciated

 

thx

it depends whether these drives have separate controllers or not.  if so, possible query accessing data in separate files groups use multiple contollers data can access simultaneously giving better performance.  if use same controller performance be helped.  if 1 or more tend grow more put on separate drives , auth growth paramters might different isn't peformance related unless auto growth occurs during insert or update.  may faster autogrow 1 smaller filegroup 1 huge database. 

 

my 2 cents

SQL Server  >  SQL Server Database Engine