The most recent content from our members.
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. *…
Need to create an email alerts for SQL ALWAYS ON.
If you are in the cloud or heading there, I'm excited to tell you Database Performance Analyzer 11.0 has your databases covered. DPA already monitors databases on cloud VMs and Amazon RDS, but now we've got each vendors database DBaaS offerings as well. Also, the updated DPA Integration Module (DPAIM) shows these new…
Currently when registering a SQL server instance that is part of an Availability Group DPA will take the listener name or virtual IP address given and will drill down and use the active node name when it connects. If the end user wants the listener DNS to be displayed then they must make an update to the COND table in the…
Hey SQL Server DBAs, I've got some questions that I'm looking for data points on: * How many primary AGs do you typically run in a given instance? Are we talking 1 or 2 or do you tend to load up primary AGs? * Would you rather monitor your AG via the AG listener with the ability to follow in the event of a failover or…
In a effort to monitor the synchronization status of every database in our SQL Always On cluster, we came up the the following PS script. Worked great in NPM v11. However in NPM V12 the message ouput is returning N/A and the Statistic output is returning NaN. When running the script within Powershell ISE, I get the correct…
This document describes how to set up two DPA Alerts to monitor cluster fail overs including AlwaysOn environments to notify you when a failover occurs and to change the Database Instance name to include the actual physical node name as well as the cluster name in DPAs Main dashboard screen.
It looks like you're new here. Sign in or register to get started.