• DPA 12.1.7 Showing CPU mismatch information OS CPU utilization is low compared to Instance CPU utilization

    DPA 12.1.7 Showing CPU mismatch information OS CPU utilization is low compared to Instance CPU utilization.  
    Profile Photo
    last modified by subhamrenu
  • FEATURE REQUEST - Send alert when the wait time is above a particular threshold Case # - 00450909

    MS-SQL Server monitoring: I want to monitor a specific SQL Hash and send an alert when the wait time is above a particular threshold. By using average, spikes do not trigger the alerts because the average results in ...
    Profile Photo
    last modified by sandoval
  • DPA SWQL SDK - Are these tables supposed to work?

    Hi All,   As much as i like the SWQL SDK i've had some frustrations with it recently   Are tables like DPA.Deadlock and DPA.ProblemSQLStatement supposed to work? I'm in an DPA integrated environment, and I...
    Profile Photo
    created by adam.beedell
  • DPA monitor DB2

    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 [S...
    Profile Photo
    last modified by bambarit
  • Typical Day of SQL Wait Graph

    Hi I am new to Solarwinds DPA and I was wondering if someone could help me please. I am looking at the typical day of sql wait graph and two of my bars are for the same job, can anyone explain why this is. Thank you
    Profile Photo
    last modified by djevans
  • Database Performance Analyzer (DPA) 2019.4 Is Now Generally Available

    DPA 2019.4 - New Alert Email Customization, Best Practices Analysis, Azure SQL Managed Instance support, and more!We are excited to announce that the SolarWinds® Database Performance Analyzer (DPA) release 2019.4...
    Profile Photo
    last modified by serena
  • Buffer Cache Size Plummeted In Latest DPA

    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 s...
    Profile Photo
    last modified by bobbyowens
  • Annoying Bug - Login Name

    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...
    Profile Photo
    last modified by bobbyowens
  • Can we keep 3 months all trace in SolarWinds ?

    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
    Profile Photo
    last modified by rrado
  • DPA Authentication Multiple Domains in Separate Forests

    Does anyone have any experience setting up DPA for multiple domains in separate forests?  I see several KBs that reference the BaseDN can be shortened to allow easy authentication of sub domains in the same fores...
    Profile Photo
    created by monitoringlife
  • How to duplicate graphs from Orion Performance Analyzer Reports?

    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 D...
    Profile Photo
    last modified by mea
  • CUSTOM ALERT - DEADLOCK

    DESCRIPTIONThis alert will detect and show deadlocks in SQL Server instance.   ALERT DEFINITIONTo create this alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Mul...
    Profile Photo
    last modified by alejandroc9003
  • CUSTOM ALERT  - COUNT BLOCKED SESSIONS ON

    DESCRIPTIONShows the number of blocking sessions.   ALERT DEFINITIONTo create this alert, click on 'Alerts' > 'Manage Alerts' tab and create a Custom Alert of type Custom SQL Alert - Multiple Numeric Return. C...
    Profile Photo
    last modified by alejandroc9003
  • How can I use a custom SQL in a MySQL alert or report?

    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 wa...
    Profile Photo
    last modified by whui1025
  • Custom alert for monitoring object changes

    Trying to create an email alert when an OBJECT:ALTERED is either changed, deleted or altered.  What is the best way of handling this.
    Profile Photo
    last modified by cybertex2
  • SQL Monitoring

    Our database team is very reluctant to provide the sysadmin credentials for the database servers. Is there any way that we can monitor the database servers without the provision of sysadmin credentials. Like in SAM, a...
    Profile Photo
    last modified by Farhood Nishat
  • DB2 doesn't work anymore since the update to 2019.4

    My DBA said that there is an error in the DPA Script....   Someone have a idea... ?   Before the update....everything worked well
    Profile Photo
    last modified by jerominus
  • Is there a ‘Comprehensive Guide for DPA for SQL Server’?

    Is there such a thing as the ‘Comprehensive Manual for DPA for SQL Server’ ?  A document, guide or manual that covers DPA For SQL Server from top to bottom leaving nothing unexplained.  I’v...
    Profile Photo
    last modified by edcarden
  • How can I view all the named queries on a server?

    Hopefully this is a simple question.   I need to view all the named queries on a server. Back some time ago I passed some tuning advice to a third party. It seems they took it, and the query I had originally nam...
    Profile Photo
    last modified by s.hoyer
  • Smart queries

    Has someone compiled queries to run against the dpa_repository database for some insight into tuning metrics versus GUI option? e.g. I researched these DPA tables and trying to decipher data !   [dpa_repository]...
    Profile Photo
    last modified by dpa1734