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...
Tag: filegroup
Some tips for using SQL Server 2016 file and filegroups
Some tips for using SQL Server 2016 file and filegroups Do not set the autoshrink feature. Autoshrinking results in some performance degradation, therefore you should shrink the database manually or create a scheduled task to shrink the database periodically during off-peak times, rather than set Autoshrink feature to ON. Place log files on RAID 1+0 (or RAID 1) disks. By […]