Is the recommendation to have different files on separate disks valid for SQL server in a SAN (RAID) network?
1
vote
0
answers
67
views
Link: https://learn.microsoft.com/en-us/sql/relational-databases/databases/database-files-and-filegroups?view=sql-server-ver15#Recommendations
> 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.
Asked by variable
(3590 rep)
Mar 25, 2022, 01:13 PM