Tips for using SQL Server 2017 file and filegroups Consider placing the log files on other physical disk arrays than those with the data files. Because logging is usually more write-intensive, it’s important that the disk arrays containing the SQL Server log files have sufficient disk I/O performance. Do not create many data and log files on the same physical...