what is the best way to see all SQL queries in performance insight for azure MySQL?

Robert Antwi 0 Reputation points
2024-09-03T15:44:36.1966667+00:00

I have enabled all logs to capture any SQL, but I am not seeing it on the Performance Insights dashboard for SQL queries that take longer than 10 seconds. any help?

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
812 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Oury Ba-MSFT 18,616 Reputation points Microsoft Employee
    2024-09-03T21:50:14.0833333+00:00

    @Robert Antwi Thank you for reaching out.

    Under server parameters Blade, did you enable the slow_query_log ?

    User's image

    Did you set up a Log Analytics workspace to collect and analyze the slow query logs.?

    Use Workbooks: In the Azure portal, under Monitoring, select Workbooks and choose the Query Performance Insight template. This will help you visualize query load, active connections, slow query trends, and details.

    Please check the below doc for furthermore details.

    https://video2.skills-academy.com/en-us/azure/mysql/flexible-server/tutorial-query-performance-insights

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.