Welcome! Use the login menu to access:
Customer Portal
SolarWinds customers can download purchased software, renew maintenance, & more in our updated Customer Portal!
After logging in, community members can rate & review SolarWinds software & participate in forums on thwack.com.
Partner Portal
SolarWinds channel partners will find all the resources they need in the Partner Portal, including exclusive partner tools.
| More

SolarWinds Knowledge Base

View Articles by Category

Category Icon Amazon AWS (DPA) (2)
Category Icon Database Performance Analyzer (DPA) (142)
Category Icon Database Problems (DPA) (29)
Category Icon Features (DPA) (40)
Category Icon Install and Setup (DPA) (103)
Category Icon Wait Time Analysis (DPA) (12)
Category Icon DB2 (DPA) (73)
Category Icon SQL Server (DPA) (92)
Category Icon Management (DPA) (63)
Category Icon Oracle (DPA) (95)
Category Icon Sybase (DPA) (67)
Category Icon VM Option (DPA) (35)
Category Icon VMware (DPA) (62)
Add an article to this category

Category » Database Performance Analyzer (DPA)rss button

There were 16 articles found in this category:

  1. questionWindows Server 2012 and SQL Server 2012 and 2014 Support
    The following SolarWinds products support Microsoft Windows Server 2012 and 2012 R2 and Microsoft SQL Server 2012 and 2014. Product Runs on Windows Server 2012 R2 since... Runs on Windows Server 2012 since... Runs on SQL Server 2014 since ... Runs on SQL Server 2012 since ... NPM (including ...
  2. questionSQL Server Long Running Jobs Alert May Fire False Positives if a SQL Job was Started and not Allowed to Finish
    In DPA 9.0 and 9.2, the SQL Server Long Running Jobs alert may fire false positives if a SQL Server job was started and not allowed to finish. (This issue is fixed in DBA 10.0.) To work around this issue, create a custom SQL alert that excludes SQL Server jobs that are started but not completed ...
  3. questionMySQL Performance Schema Configuration Options
    The following Advanced Options can be used to configure the MySQL Performance Schema: MYSQL_PERFORMANCE_SCHEMA MYSQL_PS_UPDATE_BEHAVIOR MYSQL_PS_ACCESS_ALLOWED MYSQL_PERFORMANCE_SCHEMA Select one of the following options to specify what data the MySQL Performance Schema collects and maintains ...
  4. questionNo metric data for MySQL 5.7.6 or later
    To optimize SolarWinds DPA’s reporting capabilities, we recommend the following. For MySQL 5.6, Enable the MySQL Performance Schema If the monitored database instance is version 5.6, we recommend enabling the MySQL Performance Schema. If the Performance Schema is not enabled, SolarWinds D ...
  5. questionMissing MySQL statistics and performance_schema.events_statements_summary_by_digest table is full error in the log file
    Background MySQL statistics are calculated by querying the performance_schema.events_statements_summary_by_digest table. This table has a fixed size that can be changed, but when the table becomes full, any new values not already in the table get grouped in a special NULL row. This allows MySQL ...
  6. questionMissing statistics for SQL statements
    Symptom You don't see statistics for SQL statements in SolarWinds DPA. Issue There are some common reasons for why SQL data can be missing: The MySQL performance schema might be disabled. MySQL does not provided statistics for SQL run in a stored procedure. MySQL does not provide statistics for ...
  7. questionSQL batches in MySQL affect statistics
    MySQL only publishes the information necessary to retrieve statistics for the last query in a batch of SQL statements. This affects DPA's ability to accurately report statistics for some of the SQL in the batch. As an example, take this batch of SQL statements: SELECT count(1) FROM t1;SELECT co ...
  8. questionORA-01882 Timezone region not found error when you try to register an Oracle database
    Symptom When trying to register an Oracle database, you may sometimes get an error similar to the following: The timezone on the DB instance that you are trying to register is not compatible with the DPA timezone [Pacific/Tarawa]. Error Message: The timezone name/region on the client is not supp ...
  9. questionError occurred while trying to read the license store
    The error message "Error occurred while trying to read the license store." usually indicates a corrupted license file. Suggested Action To resolve this issue, rename the licensing folder. Stop DPA For UNIX or Linux: Stop DPA using the {install dir}/shutdown.sh script. For Windows: Stop the Wi ...
  10. questionWhen DPA Runs on an EC2 Instance, Links in Emails Might Be Broken
    Emails sent from DPA (for example, alerts or scheduled reports) include a link back to the product. When DPA runs on an EC2 instance, these links might be broken. When DPA creates the links, the host name in the URL is based on the current public IP address of the EC2 instance. Whenever the ins ...
  11. questionUpdate to the latest jTDS driver for DPA 9.2
    With DPA 9.2, the default, active file is jtds-1.2.jar. If instructed to do so by SolarWinds support, you can switch to jTDS-1.2.2.sw.2.0.jar using the following procedure: Note: This updated jtds driver only works with specific versions of Microsoft SQL Server. Do not switch to the 1.2.2 jtds ...
  12. questionProtecting Against "POODLE" security vulnerability (CVE-2014-3566)
    The Padding Oracle On Downgraded Legacy Encryption (POODLE) vulnerability, released on October 14th, 2014 (CVE-2014-3566), is an attack on the SSL 3.0 protocol. Since this problem is in the protocol itself, any product using SSLv3 is affected. By exploiting this vulnerability, an attacker can o ...
  13. questionSCHEMASFED is not Replicated between the Primary and Secondary Servers when Fail Over Function is Installed and Enabled
    Issue The SCHEMASFED file filter is not replicated between the primary and secondary servers when the fail over function (SolarWinds Failover Engine) is installed and enabled. Environment DPAO 9.2 using Windows 2008 R2 and Internet Explorer 11 Resolution In SolarWinds Failover Manager, click th ...
  14. questionError or unsuccessful when trying to register a Microsoft SQL Server for monitoring
    This article applies to DPA version 9.1 and earlier. Problem You can't register a Microsoft SQL Server to monitor it. The registering process either hangs, or the monitor appears down. You may get the error message "Could not get JDBC Connection; nested exception is java.sql.SQLException: I/O E ...
  15. questionJS Stack overflow error when using Internet Explorer 8 with the DPAO integration module
    Some users may experience a JavaScript stack overflow error when using Internet Explorer 8 with the Database Performance Analyzer 9.2 Orion Integration Module. To solve this issue, install the Microsoft update for the native JSON feature in Internet Explorer 8 from the Microsoft website.
  16. questionCan't authenticate to remote DPA instances from a Central DPA using AD/LDAP
    Symptom You can't authenticate with remote DPA instances to a Central DPA when you supply a valid custom user credential to the Central -or- if you supply an invalid user credential to the Central that fails both customer and AD/LDAP authentication. Problem This is a side effect of one of our an ...