search

MicrosoftDocs / azure-docs

Open source documentation of Microsoft Azure
https://docs.microsoft.com/azure
Creative Commons Attribution 4.0 International
10.24k stars 21.41k forks source link

How to monitor performance of Read Replica? #38421

Closed ackava closed 5 years ago

ackava commented 5 years ago

How can I monitor performance of read replica, so I can plan if I need additional replica or not. There is no separation in metrics in portal.

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

KalyanChanumolu-MSFT commented 5 years ago

@ackava We are looking into your question and will get back to you soon.

NavtejSaini-MSFT commented 5 years ago

@ackava Please check the below link for complete information regarding this topic: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-read-scale-out

Specially to following section regarding monitoring the same. https://docs.microsoft.com/en-us/azure/sql-database/sql-database-read-scale-out#monitoring-and-troubleshooting-read-only-replica

We are going ahead and closing this request for now but if there are any more questions, please get back to us on this thread and we will continue the dialogue.

ackava commented 5 years ago

@NavtejSaini-MSFT I have already checked, and both methods only retain last one hour of data for replica, which is very inconvenient as now I have to write some other application to accumulate all the data to see it next day, I cannot sit every hour to check statistics.

NavtejSaini-MSFT commented 5 years ago

@ackava Yes you may have to store the data to analyze it. Additionally you can post your idea at Azure SQL Uservoice so the product team can look into it and may be take it up in future releases.