To maximize performance, create files or filegroups on different available disks as possible. Put objects that compete heavily for space in different filegroups.
Use filegroups to enable placement of objects on specific physical disks.
Put different tables used in the same join queries in different filegroups. This step will improve performance, because of parallel disk I/O searching for joined data.
Put heavily accessed tables and the nonclustered indexes that belong to those tables on different filegroups. Using different filegroups will improve performance, because of parallel I/O if the files are located on different physical disks.
Don't put the transaction log file(s) on the same physical disk that has the other files and filegroups.
In a SAN network, is there any benefit to creating files or filegroups on different disks? or any of the above quotes?
I am asking because the SAN network has multiple disks and a single file is scattered amongst multiple disks.
