Forum Discussion
Solved
What to use ReFS or NTFS?
Hi All I'm preparing for SQL Server 2022 inplace upgrade when it arrives, and have just purchased a new hardware where I will use Windows Server 2022 and SQL Server 2019 Ent. until the new toy ar...
JensNilsson , see SQL Server Hardware and software requirements => Hard Disk
ReFS is supported, but because of security reasons not recommended, so better go with NTFS.
Format the disk for data files with a sector size of 64 kb instead of default 4 kb, that's best practice.
JensNilsson , see SQL Server Hardware and software requirements => Hard Disk
ReFS is supported, but because of security reasons not recommended, so better go with NTFS.
Format the disk for data files with a sector size of 64 kb instead of default 4 kb, that's best practice.
Thanks! olafhelper
That helped my decision. The sector size I'm aware of, so that I'll fix 🙂
Have a great new year of 2022
/Jens