Tips for using Very Large Databases in SQL Server 2016 Try to create as many database files, as there are physical disk arrays so that you have one file per disk array. This will improve performance, because when a table is accessed sequentially, a separate thread is created for each file on each disk array in order to read the…