server ent 2016 max disk size

Question

Hi ;

iv got vmware 6.5esxi with MSSQL2016ENT in a always on configuration.

data on disk is approaching 2TB .NTFS.

can i increase it over 2TB???win os side?thanks

would i have to change protocol to GPT?

is it gone effect my performance?

thanks...

source link: https://social.technet.microsoft.com/Forums/windows/en-US/fab43751-4271-4607-8016-3a794420d328/server-ent-2016-max-disk-size?forum=ws2016

Answer 1

Welcome to our new Microsoft Q&A Platform.

The MBR limit is 2^32 sectors. Given the common 512-byte sector sizes, the limit is 512 * 2^32 bytes, which works out to 2 TB.

If you want to use the larger disk, you should use GPT disk.

For how to convert disk from MBR to GPT, please refer to my reply in this link:

https://social.technet.microsoft.com/Forums/ja-JP/8f1675ff-98da-4f34-b87f-d6432c180c21/mbr-to-gpt-conversion-failed?forum=win10itprogeneral

In addition, if you have used the GPT disk and format the disk as NTFS, you should know this:

https://learn.microsoft.com/en-us/windows-server/storage/file-server/ntfs-overview

Hope this can help you.