Performance Azure SQL Databases

2 Topics

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
13KViews
4likes
0Comments
Lesson Learned #195: Performance Best Practices for Azure SQL Database and Managed Instance.
We usually work on performance issues that following the best practices might be resolved following them. In this article we would like to share a PowerShell Script that checks an example best practices for Azure SQL Database and Managed Instance.
Jose_Manuel_Jurado
Apr 06, 2022 Place Azure Database Support Blog
12KViews
4likes
2Comments