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.
In Azure Database for PostgreSQL Flexible Server, you can now receive recommendations for scenarios including long-running queries, orphaned transactions, databases approaching the 1 billion transaction (aka transaction wraparound scenarios), and servers exceeding bloat ratio. These new recommendations are seamlessly integrated with the troubleshooting guides available on the Azure Portal. For more details, Troubleshooting guides for Azure Database for PostgreSQL.
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.
Long-running transaction scenario
Let us walk through a step-by-step example to get recommendations for long-running transaction and see how the integration of troubleshooting guides can assist you in resolving the issue:
1. For the recommendation, 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. Here you get the 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. Finally, we also provide you with recommendations on what steps need to be taken to resolve the issue.
5. You may have to follow a few additional steps for all other PIDs identified as long running and resolve them based on the specific 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.
