Index-Filegroup (how many Files)

SQLServerCentral » Latest topics

Index-Filegroup (how many Files)

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


Thanks
Regards
Nicole

more info...