• Blocking on SQL Server Not Turning Status Checks To Yellow or Red on Home Dashboard?

    Hello, we are running a trial and are learning the interface.  We had a SQL server that has a block and we were expecting that on the home screen one of the green checks for that SQL server would turn red, but fr...
    Profile Photo
    last modified by bharris
  • 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
  • Setting Up Alerts for SQL Deadlocks/Locks

    We have a DPA trial installed and I was looking into alerting capabilities.  Is there a way to send an email alert when a deadlock is detected? I'm seeing block wait times, but not deadlocks.  Am I missing it?
    Profile Photo
    last modified by bharris
  • 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
    last modified by chasmann
  • 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
    last modified by adam.beedell
  • DPA: Unable to register IBM DB2 database

    Hello everyone, I'm a newbie with DPA module. Currently, I’re going to demo DPA, SRM for customer. DPA can register MSSQL or Oracle successfully but can’t connect to DB2 database v10.5. I see error on sc...
    Profile Photo
    last modified by thanh.le
  • 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
  • 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 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
  • 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