Good morning,
I searched through the forum for any information related to SQL Text not showing up for a monitored secondary MSSQL replicas, but I couldn't find anything
germane.
I have a 3 node cluster/AlwaysOn AG - I added each node , the RW, RO, RO . The one I am concerned with is the RO node that has sprocs executed against it.
So I added the physical node name, with connection properties for ApplicationIntent=ReadOnly. That worked fine, the connection to monitor succeeded but the
outcome was the same - "SQL Statement not available" -
I tried with the listener name next but still no dice. I couldnt' find a configuration setting that would stop this from happening but I am wondering if any one has
had this issue ?
SQL 2019 Enterprise / Windows 2019 Server Datacenter edition