This post has been republished via RSS; it originally appeared at: Azure Database Support Blog articles.
We used to have cases where our customers reported a performance issue that is causing delay in their business, In this video below we going to provide us some insights about how to monitor your Azure SQL Managed Instance and we are going to share a query to obtain all the current processes that your Azure SQL Managed Instance.
Main Characteristics
- 99% features available from OnPremises - Compare the database engine features of SQL Database and SQL Managed Instance - Azure SQL Database & SQL Managed Instance | Microsoft Docs
How to monitor?
- Azure Portal, Azure Monitor, Log Analytics and SQL Profiler, xEvents Profiler
- Select * from sys.dm_exec_requests in combinations with other
- Query Data Store
- Use the queries provided in the demo
Best Practices
- Update Statistics with fullscan - How to maintain Azure SQL Indexes and Statistics - Microsoft Tech Community
- Lesson Learned #195: Performance Best Practices for Azure SQL Database and Managed Instance. - Microsoft Tech Community
- dimitri-furman/managed-instance: Code samples for use with Azure SQL Database Managed Instance (github.com)
How to monitor queries that are running in my SQL Managed Instance
This video about the demo how to monitor your Azure SQL Managed Instance