Get the latest news about SolarWinds Database Performance Analyzer (DPA)
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…
Hi Guys, Anyone got chance to integrate SW N-Central and SW DPA here. We have a N-Central environment and I wanted to ask if anyone done integrating this two tools. Appreciate everyones help. Thanks MCB
I'm interested in being able to extract SQL runtimes from the DPA database. I've looked in SWQL Studio but hadn't seen the data I was interested in in the Orion.DPA tables (If I'm missing it please point that out to me ). So I tried to use Invoke-WebRequest however I continued to get "Your Session has Expired...". Arguably…
It looks like you're new here. Sign in or register to get started.