Hi People,
I wanted to monitor 2 nodes Virtualized SQL Server 2017 Enterprise database cluster Always On, therefore I wonder if DPA can have some alert like the below:
- SQLServer: Availability Replica object provides performance counters that are used to monitor the performance of AlwaysOn availability replicas.
- SQLServer: Database Replica object has a list of counters that are used to monitor the performance of the secondary replicas of an availability group
perf.counter_name LIKE 'Mirrored Write Transactions/sec%'
from
object_name LIKE 'SQLServer:Database Replica%' perf.counter_name LIKE 'Transaction Delay%'
from
object_name LIKE 'SQLServer:Database Replica%' perf.counter_name LIKE 'Log Send Queue%'
from
object_name LIKE 'SQLServer:Database Replica%' perf.counter_name LIKE 'Recovery Queue%'
from
object_name LIKE 'SQLServer:Database Replica%' perf.counter_name LIKE 'Redo Bytes Remaining%'
from
object_name LIKE 'SQLServer:Database Replica%'
or this is something that SAM can perform?
Thank you in advance.