Connect with experts and redefine what’s possible at work – join us at the Microsoft 365 Community Conference May 6-8. Learn more >

query performance

3 Topics

Custom RBAC to access QPI's query text with minimal permissions
Custom RBAC to access Query Performance Insight's query text with minimal permissions. The solution described in this article applies to Azure SQL Database, Azure Database for MySQL v.5.7, 8.0 and Azure Database for PostgreSQL v. 9.6,10,11.
MelaniaNitu
Oct 05, 2023 Place Azure Database Support Blog
4.5KViews
3likes
1Comment
How to Capture the Actual Execution Plan in Azure SQL Database
This article describes steps how you can retrieve the actual execution plan of a query directly from the runtime statistics, without having to extract the query first and run it separately outside of the application.
Holger_Linke
Aug 17, 2022 Place Azure Database Support Blog
12KViews
4likes
0Comments
Automated Query Caching with the Heimdall Proxy
Improve database scale with query caching and invalidation; no application changes required.
Roland Lee
Jan 24, 2020 Place Azure Database for MySQL Blog
3.7KViews
0likes
0Comments