How can I diagnose and resolve memory-related slowness issues in my Azure SQL Elastic Pool databases?

Question

Our resources are experiencing memory-related problems, either within the Elastic pool or at the database level. I am aware that we have the Memory Percent Instance Metric available at both levels, as well as the 'sys.dm_os_out_of_memory_events' diagnostic view retrieved from this article: 'https://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-memory-errors-issues?view=azuresql'. Therefore, in order to obtain a precise diagnostic, we would like to confirm if these options are sufficient PS - Based on common issues that we have seen from customers and other sources, we are posting these questions to help the Azure community.

Answer 1

Greetings!

If your elastic pool is experiencing issues, you can start with the Query Data Store and built in monitoring tools in the portal to determine which types of waits you are experiencing. If those tools indicate that you are experiencing memory related waits, the sys.dm_os_out_of_memory_events can help you with the memory issue

Please refer to this document https://learn.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-using-the-query-store?view=sql-server-ver16

Regards

Geetha