Monitoring Read Only Replica in Azure SQL Premium range
説明
In Azure SQL, its premium range has Read Only Replica, which you can connect with ApplicationIntent=Readonly.
This can't be set this in Spotlight. In the proxy, you can only give the database name, to monitor a readonly replica. Spotlight needs to use a connection string with "ApplicationIntent=ReadOnly"
原因
This is currently not supported
対策
WORKAROUND: None.
STATUS: Enhancement request DPMSCS-I-70 has been submitted to Development for consideration in a future release of Spotlight Cloud.