Get the latest news about SolarWinds Database Performance Analyzer (DPA)
Hi Everyone, anybody can help, why this happen when trying to add DB2 monitored by DPA Date: 1/9/20, 5:03:31 PM DB: BTNMDWDEV:50000 org.quartz.JobExecutionException: DatabaseMonitorStartJob failed [See nested exception: org.springframework.dao.DataIntegrityViolationException: QuickPoll; SQL [SELECT auth_id igniteex,…
WHAT'S NEW IN DPA 2019.4 We are excited to announce that the SolarWinds Database Performance Analyzer (DPA) release 2019.4 is now available! Note that this is the first release using the new DPA version numbering format. DPA 2019.4 is the next release following DPA version 12.1. DPA 2019.4 provides numerous enhancements…
I've been going through and checking various items on our SQL server and have noticed that since the latest version of DPA was installed, all our servers Buffer Cache Size is showing as having plummeted. Some of our server were on 57Gb per day and are now showing 30Gb. When I use my own scripts I am seeing 57Gb. I can see…
Quite frequently, when I reboot and have to login to DPA, the username in the login box is someone else that uses the system (not from my PC). Does anyone else get this? Surely it's a security flaw, showing me someone else login name that's allowed to use the system. How can my PC show me the login name of someone else…
Hi, Currently in my DPA I have all trace only for one month. Can I keep 3 months all trace in SolarWinds? Best regards, Radoje
I want to duplicate the performance analyzer report (from Orion) for the following metrics: * Blocked SQL Statements * The Impact of Root Blockers * Total Instance Wait Time * Wait Time by Wait Type Which tables in the DPA repository do I need to query to return the same results?
DESCRIPTION This alert will detect and show deadlocks in SQL Server instance. ALERT DEFINITION To create this alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Multiple Numeric Return. Configure the alert similar to below. Note: When DPA executes this alert, it will substitute…
DESCRIPTION Shows the number of blocking sessions. ALERT DEFINITION To create this alert, click on 'Alerts' > 'Manage Alerts' tab and create a Custom Alert of type Custom SQL Alert - Multiple Numeric Return. Configure the alert similar to below. Alert Name: Count Blocked Sessions On Execution Interval: 10 MInutes SQL…
My requirement: I have a MySQL query that looks up the data in the performance_schema and returns the SQL statements that do not meet my performance criteria. This query returns multiple rows and columns. I want to create a SolarWinds alert that will run this query once a day and, if it returns any rows, email me the…
Trying to create an email alert when an OBJECT:ALTERED is either changed, deleted or altered. What is the best way of handling this.
It looks like you're new here. Sign in or register to get started.