The most recent content from our members.
Greetings All. A few months ago I inherited a DPA installation (ver. 2024.3). I'm a pretty good Solarwinds admin but have never worked with DPA before. License renewal time coming up and, since I am now the DPA 'guru' I'm asked how many licenses do we need to cover our SQL AG's? Taking an example cluster - call it 'AG1': >…
This is the yearly question about MSSQL Always On AG's and the lack of ability to monitor them sufficiently. How can they be monitored in SAM? I end up with 51 unknown applications. I have 150 SQL Db servers with a mix of standalone, clustered and Always On. I have AG Db's with dozens of availability groups that I am not…
I am going to start here in the DPA area. How do you setup and also monitor SQL AG groups? I tried searching in THWACK but ended up with quite a few dead links. We have quite a few SQL AG and I know in the past I have read through some documents on how to set this up but cannot find any of these now. Thank you! - Dave We…
Can we PLEASE get a flag/option [ ] in the AppInsight for SQL monitor to indicate that the App is actually mounted in an availability group. What this would do is collect only the database names from the availability group and not all 99? from the server. Activity would then relate only on the databases in the group and…
I have been asked to roll out Orion with SQL Availability Groups one active site on-premise and a passive site in the DR site. This discussion is just related to letting me know any pros or cons for using SQL HA Availability Groups for the Orion database? If you are using HA AG is your environment let me know your…
Is it possible to setup an alert on a Availability Group's estimated data loss, so, when the estimated data loss is greater than x seconds or minutes, an alert is sent?
Hi, I'm running DPA 11.1.457 and that versions add some added support for Availability groups in SQL server. I was wandering if I could see within DPA some annotations on AG failover. I can see in Resources if a vm vmotion's beteween hosts. But can I somewhere see if the SQL server becomes active on another node in the…
To kick off the Q4 releases, I am happy to announce Generally Availability of Database Performance Analyzer 11.1. This release continues to build momentum on previous releases by extending our support of Availability Groups, supporting the latest databases, and improving the DPA interface. We've also added a subscription…
What is required so that DPA (version 11.0.378) shows the "AG STATUS" tab under the instances and not only the AG listener? I've added the AG listener to DPA, and under that I can see the tab. I've also added both instances directly with their instance name but there I don't see the tab. In the logs I see that parameter…
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…
It looks like you're new here. Sign in or register to get started.