Azure Advisor provides a personalized approach to receiving recommendations for your server by analyzing its configuration and telemetry data. This service aims to enhance various aspects of your server, including reliability, cost efficiency, security, operational excellence, and performance. By leveraging Azure Advisor, you gain access to tailored, proactive, and actionable recommendations designed to help your server operate at its optimal level.

You can now receive new recommendations that include checks for long-running queries, orphaned prepared transactions, databases approaching the 1 billion transaction usage limit (to prevent potential transaction wraparound scenarios), and servers exceeding the 80% bloat ratio. These new recommendations are seamlessly integrated with the troubleshooting guides available on the Azure Portal: Troubleshooting guides – Azure Database for PostgreSQL – Flexible Server | Microsoft Learn.

You can use these troubleshooting guides to help implement the Azure Advisor Performance recommendations for your Azure Database for Postgres Flexible Server. When you receive a recommendation, you will be directed to the appropriate troubleshooting guides. Be sure to follow the prerequisites section to ensure that all necessary data is provided before proceeding with the troubleshooting steps.

Let us walk through an example of a long-running transaction recommendation and see how the integration of troubleshooting guides can assist you in resolving the issue:

1. For the recommendation on Long Running Transactions, Go to Help -> Troubleshooting guides -> High CPU Usage -> Long Running Transactions as shown in the visual. This visual highlights the troubleshooting guides available on the portal, illustrating the various scenarios they can help you identify and resolve any server issues.

2. This will provide you with PIDs for the long running transactions on the server.

3. There is a dropdown to pick a specific PID which shows you the details of the PID as below. You can go through each PID and understand what is causing the issue.

4. We also provide you with recommendations on what steps need to be taken to resolve the issue.

5. You may have to follow additional steps for all the PIDs identified as long running and resolve them based on the recommendation provided.

In conclusion, leveraging Azure Advisor and the integrated troubleshooting guides can significantly enhance the performance, reliability, and efficiency of your Azure Database for Postgres Flexible Server. By proactively addressing recommendations such as long-running queries, orphaned prepared transactions, transaction limits, and bloat ratios, you can ensure your server operates at its best.

We encourage you to explore the Azure Portal and utilize these tools to stay ahead of potential issues. Start implementing the Azure Advisor performance recommendations today and make use of the detailed troubleshooting guides to maintain a robust and high-performing database environment.

Acknowledgement: This post was co-authored by Guy Bowerman and Gayathri Paderla.

​Microsoft Tech Community – Latest Blogs –Read More