Monitor queries on secondary database when read scale out is enabled in Premium tier
Monitor queries on secondary database when read scale out is enabled in Premium tier. Currently we can only find out if query is getting executed on secondary database by using SELECT DATABASEPROPERTYEX(DB_NAME(), 'Updateability') but there is no way to identify in Query Performance Insights.
Clement Gutel commented
For hyperscale this gets really important to be able to monitor read nodes load so that we can tweak how many replicas to enable.
[Deleted User] commented
Agreed. Have to log into the secondary to get any metrics.
Also, the portal metrics tool should be able to select between primary and readonly replica.