If the server has 8 or fewer CPU cores, create the same number of data files.
If the server has more than 8 CPU cores, use either 8 data files or 1/4 of the number of cores, whichever is greater, rounding up in batches of 4 files.
For example, use 8 data files in the 24-coreserver and 12 data files in the 40-core server.

No responses yet

Bir cevap yazın

E-posta hesabınız yayımlanmayacak.

Get Application and Check Your SQL Server. You can call us to ask for further questions.