Database Performance in Azure SQL MI

Sarvesh Pandey 71 Reputation points
2020-12-09T14:04:01.1+00:00

I have a SQL MI which contains 10 database. Out 10 database, 1 database is facing issue in performance. Do I have to increase the tier of SQL MI or apply some DMV to check the issue and then increase the size of SQL MI?

What is the best practice?

Azure SQL Database
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. David Browne - msft 3,766 Reputation points
    2020-12-10T13:43:31.76+00:00

    Managed Instance has the normal performance diagnostics available on SQL Server, like the Query Store, DMVs that track wait stats and session resource utilization, as well as additional tools like Intelligent Insights and Azure SQL Analytics.