Azure SQL Database and Azure SQL managed Instance -Any pointers for rightsizing ?

Anil Kumar 225

Hello,

We are looking forward to right size Azure SQL Databases and Azure SQL managed Instances but not finding any pointers. There are no Azure Advisor recommendations other than RI, Saving Plans and AHUB. Given the count of DBs and MIs, it is not possible to do this exercise manually.

If I have a Premium Azure SQL Database with utilization so low that even Standard tier would be good enough - I just want to find out such rightsizing opportunities for both databases (DTUs, vCore) and MIs (General Purpose and Business Critical)

Applicate your Response. Thank you!!

Oury Ba-MSFT 16,986 Reputation points Microsoft Employee

2023-09-26T18:00:15.1933333+00:00

@Anil Kumar Thank you for reaching out.

In addition to @Alberto Morillo answer.

I would also suggest checking the Azure SQL Database pricing calculator. By using the Azure SQL Database DTU Calculator or the Azure SQL Database vCore Calculator, you can estimate the required resources for your Azure SQL Databases and Azure SQL Managed Instances and right-size them accordingly.

Azure SQL Database pricing In the FAQ below, you can find more details there also.

Regards,

Oury
Anil Kumar 225 Reputation points

2023-09-28T04:49:04.9133333+00:00

Thank you @Oury Ba-MSFT for taking time to help !

Actually my question was to understand how to right size existing Azure SQL DB and Azure SQL MIs. Its about cost optimization after successful migration to Azure. If I have Azure SQL MI with 10 cores but it's utilization is very low and can safely be downgraded to 4 cores without any PERF and other impact - I am on look out for such opportunities.

Applicate your Response. Thank you!!
Anil Kumar 225 Reputation points

2023-09-29T04:03:11.6733333+00:00

Thank you @Oury Ba-MSFT for taking time to help !

I will go through the mentioned articles.

#StayBlessednHappy
Oury Ba-MSFT 16,986 Reputation points Microsoft Employee

2023-09-29T15:39:11.7066667+00:00

Thank you Anil Kumar

Accepted answer

Alberto Morillo 33,176 Reputation points MVP

2023-09-26T19:02:37.85+00:00

The Azure Data Migration Assistant tool has a SKU or service tier recommendation feature that allows you to both collect performance data from your source SQL Server instances hosting your databases, and recommends minimum Azure SQL Database, Azure SQL Managed Instance, or SQL Server on Azure VM SKU based on the data collected. The feature provides recommendations related to pricing tier, compute level, and data size. This functionality is currently available only via the Command Line Interface (CLI).

In addition, the Azure SQL Migration extension for Azure Data Studio helps you to assess your database requirements, get the right-sized SKU recommendations for Azure resources, and migrate your SQL Server database to Azure. This documentation helps you to learn how to collect performance data from your source SQL Server instance to get right-sized Azure recommendations for your Azure SQL targets, including Azure SQL Database and Azure Managed Instance.
Please sign in to rate this answer.
Oury Ba-MSFT 16,986 Reputation points Microsoft Employee

2023-09-26T19:27:17.01+00:00

Anil Kumar

Please don't forget to mark as accept answer if the reply from @Alberto Morillo was helpful.

Regards,

Oury

Anil Kumar 225 Reputation points

2023-09-28T04:46:57.38+00:00

Thank you @Alberto Morillo for taking time to help !

Actually my question was to understand how to right size existing Azure SQL DB and Azure SQL MIs. Its about cost optimization after successful migration to Azure. If I have Azure SQL MI with 10 cores but it's utilization is very low and can safely be downgraded to 4 cores without any PERF and other impact - I am on look out for such opportunities.

Applicate your Response. Thank you!!

Alberto Morillo 33,176 Reputation points MVP

2023-09-28T05:51:43.4733333+00:00

Before you scale down (downgrade) any database service tier or SKU, Please analyze the output of this Management View to identify patterns on resource consumption. If you see that all hours all days of the week the resource consumption are low, then proceed to scale down the database. If you identify different patterns of consumption (for example different consumption during business hours, on week days at nigh, on weekend another pattern, on holidays another one) then use Azure Automation to schedule the scale up or down of the database as needed.

Anil Kumar 225 Reputation points

2023-09-28T07:52:40.1766667+00:00

Thank you @Alberto Morillo for your valuable response.

As we don't have access on DBs/MIs, is there any other way other than using mention DMV?

Appreciate your response if your schedule permits. Thank you.

Alberto Morillo 33,176 Reputation points MVP

2023-09-28T12:36:49.3+00:00

Are you able to create an app to consume REST API data coming from Azure SQL REST API and Azure Insights REST API?

Do you have access to see the waits processes, queries, sessions are generating on that database? This could give you an idea of the need to scale up or down.

Do you have access to monitoring tools that can collect performance and connectivity data from Azure SQL database over time? Even an open source software like Grafana can help.

Anil Kumar 225 Reputation points

2023-09-28T14:09:05.2666667+00:00

Thank you very much @Alberto Morillo for your valuable response - Appreciate it !!

Will explore additional pointers provided by you..

Glad to mark your first response as answer as later responses were comments.

#StayBlessednHappy

Alberto Morillo 33,176 Reputation points MVP

2023-09-28T14:21:17.2433333+00:00

Any further question do not hesitate to contact me by mentioning me here.
Sign in to comment

1 additional answer

Oury Ba-MSFT 16,986 Reputation points Microsoft Employee

2023-09-28T21:51:39.1766667+00:00

Anil Kumar

There is no such thing is Azure SQL MI 10 cores.

Please note that right-sizing an Azure SQL Database requires careful analysis and testing to ensure that performance is not impacted. It's also important to monitor the performance and resource utilization of the database over time to ensure that it continues to meet the workload demands.

This may help Optimize your Azure SQL Managed Instance cost with Microsoft Azure Well-Architected Framework

And

https://learn.microsoft.com/en-us/azure/azure-sql/database/query-performance-insight-use?view=azuresql

Regards,

Oury
Please sign in to rate this answer.

1 person found this answer helpful.
Oury Ba-MSFT 16,986 Reputation points Microsoft Employee

2023-09-29T16:16:52.6866667+00:00

Anil Kumar

I would like to thank you for your feedback provided on survey. We found your recent engagement on this question was rated low. However, we were able to share some additional information that could helped in the later answer. Would you please re-evaluate your feedback.

Regards,

Oury
Sign in to comment

Share via

Azure SQL Database and Azure SQL managed Instance -Any pointers for rightsizing ?

1 additional answer