Get the latest news about SolarWinds Database Performance Analyzer (DPA)
Is there a standard alert that informs the administrator when a DPA monitor is OFF or unresponsive? Or is it possible to create an alert that will effectively monitor the monitors?
can it be done? we purchased 2 liscense of dpa to move around our customers to monitor their sites as needed. first one went smoothly and i am getting data second one failed because my user did not have proper permissions. third one worked up to the point of trying to connect to the insance being monitored. which is sql…
SQL query to fetch Availability group replicas failure readiness & estimated data loss from Solarwinds DPA database. Is there any specific table I can look for to fetch the availability group replicas details.
Can anyone help me with query to fetch CPU peak % (last 2 hours) for any specified database node either from DPA reporting database or are any APIs available to fetch this information.
Stupid question I'm sure, but in an effort to limit the amount of necessary licenses, is monitoring the HA pair sufficient in lieu of monitoring the actual servers themselves? Thanks!
I want to list all MSSQL Indexes which are unused from the last system restart and compile them for a cleanup. Could you please suggest if we could query DPA database to get the details.
We're looking to track table growth over time, and alert on sudden spikes in data growth. We also want to track and alert on data usage (i.e. queries against the data). Is there a way to leverage DPA to accomplish either of these? If so, has anyone done either of these using DPA? I know DPA can do custom metrics, but I…
Type Custom SQL Alert - Single Alert Status ReturnDescription Executes a user-defined SQL statement that will return a single string value that represents an alert status. Valid values are: NORMAL, INFO, LOW, MEDIUM, HIGH This alert monitors the status of commands to ensure they are executed correctly. It captures issues…
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': >…
Hi All- As subjected, need help in creating a report to check active sessions count per monitored instances across DPA. The reason i am doing this as we are facing issue with memory leak and causing outages. Saw below in system requirements These are estimates. They are based on testing done with an average of 2-3 active…
It looks like you're new here. Sign in or register to get started.