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

2 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