Share via

How to troubleshoot memory issues, either at the Elastic pool or database level?

GeethaThatipatri-MSFT 29,017 Reputation points Microsoft Employee
2024-07-18T13:35:52.23+00:00

We would like to request some assistance to monitor if our resources are experiencing memory-related problems, either within the Elastic pool or at the database level.

PS - Based on common issues that we have seen from customers and other sources, we are posting these questions to help the Azure community.

Azure SQL Database
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Rahul Randive 9,176 Reputation points Microsoft Employee
    2024-07-18T13:45:06.0866667+00:00

    Greetings!

    Welcome to Microsoft Q&A forum.

    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.

    Monitor performance by using the Query Store

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

    In addition to the Memory Percent Instance Metric and the 'sys.dm_os_out_of_memory_events' table, the troubleshooting documentation is a great reference point. This document gives you details on troubleshooting using Extended Events and the Query store as well.

     Troubleshoot out of memory errors with Azure SQL Database

     https://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-memory-errors-issues?view=azuresql

    Thank You!

    0 comments