DB VM server sizing - Need advise

Madhu Boyapati 0 Reputation points
2023-12-01T13:41:34.15+00:00

Hello Experts,

Need your help in database VM Sizing ! For a new application requirement, we are asked to provide specs for Database VM. There was a big debate within our SQL team but no definite conclusion made.

So could you pls help on below points ?

  1. what all metrics to consider for Database VM Sizing ?
  2. Do we have any direct formula to Size database server specs ? 

Kindly advise on these points so that we shall try to implement the same to our DB server.

Thank you all in advance!

 

Regards,

Madhu 

Azure SQL Database
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,563 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,339 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Javier Villegas 900 Reputation points MVP
    2023-12-01T14:59:59.6733333+00:00

    Hi Mudhu,

    Most important thing is to consider CPU , Memory and IO. All three metrics are key.

    Unfortunately there is not a formula to get the right size. The main benefits in Azure is that you can scale up and down any Azure VM so if you need more horse power you can easily do it.

    It is also important to follow the best practices for SQL Server on Azure VMs to make sure to take all the benefits

    Best practices for SQL Server on Azure VMs

    Regards

    Javier

    0 comments No comments