• Merging/Joining 2 DPA Repositories

    Hi,   We have 2 servers with 2 DPA installations and 2 repositories, one of them internally and the other one in an Azure server. We want to migrate the internal one to the Azure server and we want to be able to...
    Profile Photo
    last modified by aiglee.castillo
  • No response when click Create New DPA Repository

    I am trying to install DPA 12 in a VM running Windows Server 2012 and SQL Server. When I click on "Create New DPA Repository" there was no response. May I know what is the reason?
    Profile Photo
    last modified by sheushen
  • Custom Alert - Jobs running longer than usual

    This computes the average duration of a job from the job history tables, and computes a number representing how many times longer it is currently running than usual.   For example. Job1 usually takes 30 minutes...
    Profile Photo
    last modified by glutenfreesql
  • Which wait types constitute "Memory/CPU"

    Can someone please tell me which SQL Server wait types constitute "Memory/CPU" in DPA? It's always the largest portion of my waits and I'm not sure specifically what they are since other CPU waits like SOS_SCHEDULER_Y...
    Profile Photo
    last modified by chuckh1958
  • Do you manage Oracle Databases with DPA?

    If so, we want to talk to you!   The DPA team is working on refreshing their registration flows and we have some specific questions related to Oracle.   Please email me at carley.cousineau@solarwinds.com if ...
    Profile Photo
    last modified by ccousineau
  • Number of CPU & Memory Spike of a Node information Stored in which Database table

    Hello,   I want to know in which database table of solarwinds the number of CPU & Memory spike of a Nodes information gets stored.
    Profile Photo
    last modified by datta.sakore@bentley.com
  • Using DPA to find what queries are running at a particular point in time

    Hi have a slight issue in that I am not a DBA so I'm not 100% sure what to look for. We had an issue last night on one of our main BI DBs where IO to the Temp DB drive went nuts;   Log Name:  Application So...
    Profile Photo
    last modified by nbs
  • Host Dropped Received Packets - VM Option

    Hi guys,   I have two SQL servers on two different ESX host which have the VM license enabled.   Both have a lot of "Host Dropped Received Packets"   I see between 50 000 and 150 000 "host dropped re...
    Profile Photo
    last modified by mattsbr
  • Is it possible to configure MS SQL DPA to monitor only one database in instance

    Is it possible to configure MS SQL DPA to monitor only one database in instance? Thanks
    Profile Photo
    last modified by ipolishchukparker
  • DPA monitoring of single database on shared instance

    We want to monitor a client of ours with DPA but they have a very particular architecture. They have a single DB instance with multiple databases, and we only own one of the databases. We would need DPA to be able to ...
    Profile Photo
    last modified by aiglee.castillo
  • Adding Critical for jobs that are failing

    I want to add critical for selective jobs under 'SQL Server Job Failure' alert type. How can I  do that ?
    Profile Photo
    last modified by oindrilaband
  • Currently evaluating DPA seeing lots of wait time caused by CPU/RAM but...

    Not seeing excessive CPU utilization and have allocated the max that SQL 2017 will allow for RAM and he'll have plenty of overhead for the OS. For instance I'm seeing a lot of wait time sourced from CPU/RAM this morni...
    Profile Photo
    last modified by badgenes
  • DPA depreciating support for older SQL Server Instances what happens if we update?

    Hello DPA.  I was planning on updating the version of DPA that we run until one of the DBAs pointed out this feature below.   So at this point it looks like I will have to remain on 12.1.6 until at some ...
    Profile Photo
    last modified by martian monster
  • DBA\Ignite DB consuming 2 TB Space

    Hi Team,   We are seeing huge amount of growth in following tables which store execution plan and query text, I would like to check following things:   Can I check if purging is working\not working? Any w...
    Profile Photo
    last modified by vikasrana
  • Trending / Current Hogs by User

         I'm positive I'm not the first to ask this, but I spent about 20 minutes looking for the answer must have lost my ability to search today...   Can someone point me to instructions on how...
    Profile Photo
    last modified by soldstatic
  • Decrease in WRITELOG waits leads to an increase in Memory/CPU waits

    Hello,   We have been testing a NetApp SSD to compare performance from our Hitachi SAN.  One of our "problem" databases is SolarWinds_NPM which has an enormous amount of WRITELOG waits. After migrating the...
    Profile Photo
    last modified by jsql
  • Need a tempdb alert for actual space used

    Hi,   I need an alert that sends a message when the actual tempdb usage is 80%. Our tempdb is pre-sized but I need to know when it close to filling up.
    Profile Photo
    last modified by philter
  • tracking reads/sec and writes/sec

    I dont see the above metrics being tracked in DPA for my SQL Server 2005 instance. Does DPA track those metrics?
    Profile Photo
    last modified by sasi_dba
  • Can DPA be installed to MSSQL without a sysadmin login for the repository and/or for monitored MSSQL servers?

    For installation of a DPA data repository in an MSSQL server, can it use an already existing login that is dbo in an already existing db   For registering an instance of a MSSQL server to be monitored, can I run...
    Profile Photo
    last modified by benjamingslade
  • AUTOMATIC SCHEDULLER AS  A TASK OR REPORT WITH GRAPHICS  OF OPCION "RESOURCES"

    I would like to know and suggest the opcion to add the graphics or other information and send it by mail in AUTOMATIC way or using the SCHEDULLER as a task scheduled at night to send by mail. I found a manually opcion...
    Profile Photo
    last modified by oscarguevara