• 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
  • How to query DPA database to get same metrics as Perfstack through DPAIM

    I have DPA 12.1.698 installed using MySQL 5.7.9 (hey, it's free - don't judge ).  I want to run queries directly against the DPA repository to yield the same results as Perfstack would.  Longer story but I a...
    Profile Photo
    last modified by tony.fountain@wtainc.com
  • 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
  • DPA alert for PLE

    Hi,   I want to create a alert when the PLE < 300seconds. Which values should I use for calculation and percentage?
    Profile Photo
    last modified by philter
  • Proxy dpa:8123 via apache httpd with context-path

    Redhat Linux 7, DPA 12.0 (haven't gone to 12.1 yet), Apache httpd 2.4.x (that comes w/RHEL7)   I'd like to access DPA via apache httpd rather than directly to the tomcat app running on 8123. Now: https://mymoni...
    Profile Photo
    last modified by pthirose@ucdavis.edu
  • DPA show fragmented indexes

    Hi,   I'm fairly new to using DPA, and I'm not finding what I need. For a very specific scenario, we've got a DPA instance running for our developers. I know in Orion, you can drill down in to individual databas...
    Profile Photo
    last modified by scott.wheeler
  • Job Failure

    Description This alert will look for jobs that have failed since the last time this alert executed.  The #FREQUENCY# variable provides the number of minutes between each run of the alert (specified in the Executi...
    Profile Photo
    last modified by mandevil
  • metric results accuracy

    Hello,   I am using ignite DPA for past 3 days for monitoring a sqlserver 2008 R2 which hasnt been rebooted in an year. Application seems to be running slow for the past few days and I am currently looking at th...
    Profile Photo
    last modified by sasi_dba
  • Where is the pre-configured SQL Server historical repository on AWS?

    Hello!   I saw the statement "You can now get a ready-to-go image that includes Database Performance Analyzer and a pre-configured SQL Server historical repository. " on this page: Amazon RDS Database Monitoring ...
    Profile Photo
    last modified by samdp
  • Integrate With Multiple SolarWinds Instances

    We have a couple SolarWinds instances, and would like to take advantage of the application mapping detection. Is it OK to integrate multiple distinct SolarWinds instances with DPA?
    Profile Photo
    last modified by thwack212
  • querying dpa_deadlock_capture xe

    when we un-monitor a server, (hoping for more licenses!!) the dpa_deadlock_capture is left, and deadlocks are not picked up in the system health xe. I'm wondering if anyone has written a handy query to read the dpa_...
    Profile Photo
    last modified by rottengeek
  • DPA between server in different network

    Guys how I can configurate 2 differents lan for user DPA ?   tks. hor help.
    Profile Photo
    last modified by cjfranca
  • Question about Manage Central

    Good Afternoon!  I finished the LDAP configuration switch this morning to a new domain and it is working out great.   I am doing some looking around and found this tab which is pointing to our old Solar...
    Profile Photo
    created by martian monster
  • DPA Login and alerting Questions

    Good afternoon!   I have a domain/LDAP question about flipping domains and I will try to explain things here the best I can.    We have a multi domain environment and currently have Domain A syncing...
    Profile Photo
    last modified by martian monster
  • Buffer Cache Size & Buffer Pool Extension

    Hi,   Our production SQL Servers here all haved 100Gb of buffer pool extension. Each machine has 64Gb RAM. DPA is showing the Buffer Cache Size at just under 60Gb. Could someone please answer the following for m...
    Profile Photo
    created by bobbyowens