Introducing new troubleshooting guides features

  • Thread starter Thread starter Shashikant_Shakya
  • Start date Start date
S

Shashikant_Shakya

We are excited to announce the release of new features aimed at enhancing the troubleshooting experience in Azure PostgreSQL Flexible Server. These features provide detailed insights and metrics, enabling you to optimize your database performance effectively.



Here are the use cases where these features can be used:

Enhancements to autovacuum monitoring:​




One of the significant enhancements is the addition of table-level autovacuum details. This feature allows you to:

  • Monitor the number of times autovacuum ran.
  • Check the number of dead tuples cleaned or not removed.
  • Track the time taken to run the autovacuum.

large?v=v2&px=999.pngAutovacuum per table

Furthermore, we now display the configuration of some important parameters which control autovacuum. We validate some of those parameters and warn you if we consider that the existing configuration might cause issues with the correct functioning of autovacuum. We have also added a new Enhanced metrics tab which displays the Maximum number of Transaction IDs in use and the Oldest backend XMin metrics to provide a comprehensive view of autovacuum health.



large?v=v2&px=999.pngAutovacuum configuration



large?v=v2&px=999.pngEnhance metrics

Enhancements to the CPU troubleshooting guide:​


To help you manage high CPU usage, we have introduced several new features:

  • Parameter check for excessive logging that might impact the CPU usage and overall server performance.
    large?v=v2&px=999.pngPotential excessive logging insight
  • New "Top queries by total duration" tab which displays Query Store queries with total time.
    large?v=v2&px=999.pngTop queries by total time
  • New insight card showing sessions whose state is idle and have an open transaction.
    large?v=v2&px=999.pngIdle in transaction session insight
  • New tab to showcase PgBouncer metrics and best practices:
    large?v=v2&px=999.pngPgBouncer metrics


    large?v=v2&px=999.pngPgBouncer recommendations


  • A new tab to display the locking information: In this section, you can get the overview of locks in your server.
    • You can get the count of sessions involved in Locks.
      large?v=v2&px=999.pngLocking and blocking


      large?v=v2&px=999.pngSessions count with lock wait event
    • You can monitor the acquired locks duration during the specified time.
      large?v=v2&px=999.pngDuration of acquired locks
  • You can also get insights on blocking session where sessions are still waiting for lock acquisition.
    large?v=v2&px=999.pngBlocking information

Enhancements to the memory troubleshooting guide:​


For troubleshooting high memory usage, we have added validation for memory parameters where it can show you an insight when you change these parameters higher than defaults.

large?v=v2&px=999.pngMemory parameter check insight

We have also introduced an insight for long (>24hrs) idle sessions that might consume server resources.

large?v=v2&px=999.pngLong idle session insight

We believe these new features will significantly enhance your ability to troubleshoot and optimize your Azure PostgreSQL Flexible Server. We look forward to your feedback!



Getting started:​


To learn more about the troubleshooting guides, visit our documentation below:


Continue reading...
 
Back
Top