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.
[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.