SQLTeam.com | Weblogs | Forums

Index filegroup and files


I have created an index filegroup (NonClustered) on a separate device.
How many Filegroup-files do you recommend for this index filegroup (DataWarehouse with 1200 Tables)
CPU=24 Cores; Device=Fusion-IO

Nicole Rolleyes


Are the tables partitioned? If so, depending on the partition granularity, I'd go with one FG-file per partition. If not, it might be worth considering.

Otherwise, the number of FG files will be dependent on the amount of data and how it is accessed, note that if those FG files are all on the same device, multiple files may not help since you'll get contention anyway.

Look at partitioning, though