Get the latest news about SolarWinds Database Performance Analyzer (DPA)
Hi, I am trying to figure out an availability alert that will work for us and nothing seems to work as expected. We are monitoring 15 DBs from the same DPA instance. I want to be notified if we have issues accessing any of the DBs. I tried the "Database Instance Availability" alert, and even though it did notify me, I want…
I tried opening a case for this issue and received no resolution. When attempting to investigate why stored procedures are spending time at certain points in the procedure, I try to generate a query plan to see what is happening with that code block. Most times I get my query plan but others fail with the following error:…
Hi Team What all we can monitor for sybase SRS and IQ using Solarwind DPA or any other module ?
HI Team, Is below parameter can be monitor through DPA * SQL Cluster failover * Blockings & Lock Monitoring * Long Running queries * Instance Availability * Mirroring status Regards Sam
Over the weekend we got this message in the DPA business layer log; 2019-04-28 13:02:21,600 [13] ERROR SolarWinds.Orion.Common.SWEventLogging - Service was unable to open new database connection when requested. SqlException: Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login…
Has anyone put DPA up in the Amazon cloud to monitor Amazon Aurora (similar to MySQL v.5.6)? * How did you monitor both the Writer and Reader? * Are you able to monitor any of the AWS CloudWatch metrics? * Did you have to create a DPA in each Region & VPC? (we are in multiple Regions and multiple VPCs. Security won't let…
Hi, I've been really slowly hacking my way to be able to use the information in the dpa db and one of my attempts includes using the url from the wep page that has the data on it that I'd like, and putting it in Postman. Below is a sample serverName.as.local:8123/.../database.iwc A problem I'm currently facing is that when…
Hello, id like to use Solarwinds monitoring while I performance test software. I am trying to automate this process and am wondering if it possible to script the following: -Register a DB for monitoring -UnRegister a DB for monitoring -Update the DB Instance name (to save the DB metrics for later down the road) If its not…
Hi all - we recently implemented DPA in our environment. We have a database server that is shared across multiple facilities. Is there way a to create a custom alert when a specific hostname connects to run queries on any of the databases? thx in advanced
DESCRIPTION This alert will list SQL Statements that have recently executed outside their normal execution time. The previous 14 days are compared when calculating the average execution time for a SQL. The results are reported back in percentage above normal executions time, e.g. if 200 is returned that means the query…
It looks like you're new here. Sign in or register to get started.