• How to get Interface status and LED icon on this SQL script

    I need some help whit this SQL script i have used in the Report. Need to get the Status of the interface if its up or down and whit LED icon. Can anyone help whit this?   select Interfaces.nodeID AS NodeID, No...
    Profile Photo
    created by chasmann
  • automating annotation creation in DPA when objects are changed in SQL

    I would like to have an annotation automatically created when objects (stored procedures, indexes, etc.) are created or changed.   Does anyone already have a script to do that? Or, just point me to the DPA table...
    Profile Photo
    last modified by tjk15
  • DPA Orion Integration Module Question

    Hello DPA -   I did the 2019.4 update to DPA and was going to run the Orion integration module and then had a question.   All of my other Orion modules are on 2019.2 and DPA is on 2019.4 - if I run thi...
    Profile Photo
    last modified by martian monster
  • Privilege

    In DPA, when choosing a monitored server, then wait status, and I can see a current tab on the top of the screen, After clicking it, I can see currently active sessions and currently blocked sessions.   In the ...
    Profile Photo
    last modified by anncao
  • Can we check and find the CPU, Disk I/O and CPU usage queries wise

    I want to check in detail my all queries by CPU core usage, and Disk I/O wise is it possible to find with help of DPA 2019.4.1054. If yes please share the steps to check it.
    Profile Photo
    created by subhamrenu
  • Anyone utilize this product to it's fullest extent? Do you see the value?

    We do not have a DBA on staff but we do own this tool.  I opened up a support ticket but they stated they could not assist in actually using it so I'm curious on suggestions on how to use DPA to find why a sql en...
    Profile Photo
    last modified by cfizz34
  • Standard SQL Server Alerts

    I just installed DPA. Does anyone have (or can they create) a list or script of the standard SQL Alerts they are running with DPA for SQL Server? I have not set up a monitoring tool before and need suggestions or a te...
    Profile Photo
    last modified by tshirey
  • 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