Share via

sql server installation

emerson guimaraes 0 Reputation points
2023-08-21T18:34:45.1833333+00:00

Good afternoon, I'm installing a new database server with enterprise SSD on windows server 2022. My database has 700GB of mdf and 350 LDF.

I'm going to create the partitions SWAP - SQLDATA - SQLLOG - SQLTEMPDB - SQLMSDTC - SQLBACKUP, my doubts which file system format the partitions to have a better performance, NTFS or ReFS and the size of the allocation unit 64k, 128k, 256k, 512k, 1M or 2M.

Thanks for the help.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AniyaTang-MSFT 12,451 Reputation points Microsoft External Staff
    2023-08-22T02:35:55.1166667+00:00

    Hi @emerson guimaraes

    NTFS with a 64K allocation unit size is the most common case.

    From what I've searched, ReFS is a newer technology and it may have some bugs that we haven't found. While NTFS has always been around, it's a proven file system at this stage.

    For more details, you can refer to these links:

    https://www.reddit.com/r/sysadmin/comments/sh3ds6/are_you_using_refs_or_ntfs_for_you_sql_servers/

    https://www.arcticdba.se/sql-server-disk-settings/.

    If the answer is useful, please click Accept Answer to let others with similar questions quickly find answers. If you have any questions, please feel free to let me know.

    Best regards,

    Aniya

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.