Azure Managed Instance Monitoring and Performance Tuning

In this video we had a discussion about CPU Bound Query. I made use of Ostress tool to generate a workload. Most of the wait types are associated with SOS_SCHEDULER_YIELD. To overcome the issue we increased the Virtual Cores. Also we discussed about Parallelism Inhibitors which prevented the execution plan of the CPU Bound query to go for parallelism. The other Performance issue is with DML operation where the wait types are associated with Write Log. At first the query ran for 51 seconds and after fine tuning the log file settings it has come down to 26 seconds and later we performed the transaction in a batch by introducing Begin tran and commit Mode. Also we discussed about Monitoring Azure Managed Instance with SQL Insights and Monitor.

[@srinivask8904]

Hi Vamsy, recently we have experienced one issue with our SQL MI.
Issue: The connection to the DB is getting lost from time to time, and the issue is intermittent.
Error Message: SQL ServerException: The connection is closed.
When we run some query directly on Managed instance giving result in 1 sec for 18k records, but the same query running from application side taking 20 sec time and some times losing connection.
if any idea please help to share here...thank you

[@vamsychiranjeevi9619]

Well I addressed this in another session of my training. Can you check the set Attributes from the Application?

[@rajeshamanaganti]

Are you starting new batch training

[@vamsychiranjeevi9619]

Yes...But only on Managed instance with some advanced topics

[@sreenug6288]

Hi @@vamsychiranjeevi9619 , please let me know MI and advanced topics new batch training

[@vamsychiranjeevi9619]

@@sreenug6288 Kindly pine me on my WhatsAPP [phone]