Query on Data Disk

Question

I want to instal SQL server on Azure VM. For test and Production. How many data disks are required and what should be sizes of each of them.

Answer 1

@Shailesh Ganesh Shripati Thank you for reaching out.

To create an install SQL server on Azure VM on windows, you either choose the Portal functionality, Bicep, PowerShell or ARM Template. See doc https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/sql-vm-create-portal-quickstart?view=azuresql&tabs=conventional-vm

How many data disks are required and what should be sizes of each of them.

Regarding the number and sizes of data disks required, it depends on the IOPS, throughput, and capacity requirements of your workload. Azure managed disks offer five disk types: Ultra Disks, Premium SSD v2, Premium SSDs, Standard SSDs, and Standard HDDs. See https://learn.microsoft.com/en-us/azure/virtual-machines/disks-types

The checklist in this section covers the storage best practices for SQL Server on Azure VMs.

• Monitor the application and determine storage bandwidth and latency requirements for SQL Server data, log, and tempdb files before choosing the disk type. See Storage

To create a Linux virtual machine with SQL Server see https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/linux/frequently-asked-questions-faq?view=azuresql#how-do-i-create-a-linux-virtual-machine-with-sql-server-

Please let us know if you need more information or further clarification.

Regards,

Oury

Answer 2

How many data disks are required and what should be sizes of each of them.

Without knowing your initial data size and data growth per period no one can guess.