Release date: November 7, 2017
These release notes describe the new features, improvements, and fixed issues in Database Performance Analyzer Integration Module 11.1. They also provide information about upgrades and describe workarounds for known issues.
If you are looking for previous release notes for DPAIM, see Previous Version documentation.
New features and improvements in DPAIM 11.1
DPA data in Performance Analysis (PerfStack™) dashboards
You can add DPA data to PerfStack dashboards, including wait time, database metrics, VM metrics, and custom metrics. When you identify a time period with significant wait times, you can use the Data Explorer to examine the SQL statements that were executed during that period.
Both DBAs and non-DBAs can use PerfStack to correlate database metrics with other Orion Platform metrics, and identify relationships between database wait times and other factors in the environment.
Blocking and Deadlocks resource
When you drill in to view details about a monitored database instance, the summary view includes the Blocking and Deadlocks resource. Use this resource to determine if blocking sessions and deadlocks are affecting performance. It includes the following tabs:
- The Top Waiters tab identifies the sessions that are affected by blocking. These sessions are idly waiting for a locked resource to be released by another session.
- The Top Root Blockers tab shows what the root blocker transactions are doing and their impact on all sessions that they are directly or indirectly blocking.
- (SQL Server and Azure SQL database instances only) The Deadlocks tab shows the number of deadlocks that occurred in each time period. Deadlocks occur when two sessions have a lock on different resources, and each session needs a resource held by the other to complete its task.
The Blocking and Deadlocks resource is not available for Db2 database instances.
Stand-alone DPAIM installation
DPA users who do not own other SolarWinds products can install DPAIM stand-alone and access DPA data from the Orion Web Console. Orion features such as PerfStack and customizable dashboards are available for use with DPA data. See New customer installation for more information.
Simplified and improved resources
DPAIM resources have been updated to make it easier for users to identify databases with performance issues. In DPAIM 11.0, the database instance status was changed to reflect only wait times. Other metrics (such as memory or CPU usage) might be high, but they don't indicate a database performance problem unless users are experiencing long wait times.
DPAIM 11.1 includes the following additional improvements.
All Database Instances resource (Database Summary view)
The filters at the top now include all statuses. Use these to filter by one or more statuses. You can also use the drop-down menu to filter by database type.
To keep the focus on database performance issues, the resource no longer displays status information for other metrics, such as memory or CPU usage. (If you want to display this information again, see Displaying metrics below.)
Database Response Time resource (Database Instance view)
Like the All Database Instances resource, the Database Response Time resource shows only the wait time status. Status information for other metrics has been removed. (If you want to display this information again, see Displaying metrics below.)
On the SQL tab, the legend now shows the SQL hash or the custom name assigned in DPA, instead of SQL text. You can click the hash or name to open the SQL Detail window, described in the following section.
SQL Detail window
Click the SQL hash or name in any resource to view detailed information about a SQL statement, including:
- Any advisors for the statement
- The total response time in the past 2 hours
- The number of executions in the past 2 hours
- The SQL text
Click View in DPA to display historical information about the SQL statement in DPA.
If you want the All Database Instances resource and the Database Response Time resource to display metrics again, you can change an Orion Advanced Configuration setting:
- Log in to the Orion Web Console using an account with administrative privileges.
In the address field of the web browser, enter the following:
- Under DPA.DatabaseInstances.Settings, select ShowKpis.
- Click Save.
Improved wait time status information from DPA
DPA 11.1 uses the same statuses as the Orion Platform: green (normal), yellow (tracking high), and red (tracking very high). This allows DPA and DPAIM to display status information consistently. In addition, DPA updates status information once every 10 minutes instead of once an hour.
When you are integrating a DPA server, DPAIM checks to make sure that the DPAIM and DPA versions are compatible. If an incompatibility is detected, a message tells you what version of DPA or DPAIM is recommended or required, and provides information about the new features in that version.
New features and improvements in Orion Platform 2017.3
Dashboards and widgets
The new Customize Page significantly simplifies and streamlines how you build your dashboards or views. Drag and drop resources, now known as widgets, exactly where you want them on your page, including on to blank areas to create new columns.
- Start searching for widgets in two clicks from any customizable page.
- Mark favorite widgets so you can quickly add them to new dashboards or pages.
- Drag and drop widgets directly on to the pages or move widgets to new locations.
Secure the connection between your Orion server and your SQL server
Increase your security compliance by using Windows authentication for both day-to-day data storage and retrieval between your Orion server and your SQL server and during the initial setup of your database server in the Configuration Wizard.
Do not use a Windows account with a password policy applied.
You can also enable SSL directly in the Configuration Wizard to encrypt the information exchanged between your Orion server or additional polling engines and your SQL server, independent of SSL settings on your SQL server.
SSL must be configured on your SQL server to utilize this feature.
DPAIM can be installed in either of the following ways:
With SolarWinds SAM
DPAIM is automatically installed with SolarWinds SAM 6.2.1 or later. If you have SAM 6.2.1 or later, you do not need to install DPAIM. All you have to do is set up the integration module.
To install SAM, use the SolarWinds Orion Installer.
Standalone (SAM not required)
If you do not plan to install SAM, download and run the SolarWinds Orion Installer to install DPAIM as a separate product. You can install DPAIM alone, or you can install DPAIM with other Orion Platform products such as SolarWinds SRM.
After you install DPAIM, you must set up the DPA Integration Module.
Before you upgrade!
DPAIM 11.1 no longer supports Windows Server 2012 or 2012 R2 for Orion Platform installations. Upgrade to Windows Server 2016 before you upgrade DPAIM.
How to upgrade
If you are upgrading from a previous version, use the following resources to plan and implement your upgrade:
- Use the SolarWinds Orion Installer to build your upgrade path and upgrade all Orion Platform products.
- When you are ready, download the upgrade package from the SolarWinds Customer Portal.
DPAIM 11.1 fixes the following issues.
|You can mute or resume alerts in the Orion Web Console even if the associated DPA server is down.|
|DPAIM resources display data correctly even if the Orion Platform setting
|DPA integration no longer fails when a node's DNS property contains a square bracket ([).|
|DPAIM can be upgraded or uninstalled on a server that does not have .NET 3.5 installed.|
|Custom resources are rendered correctly when the Business Layer is down.|
|You can create a new group with database instances even when one or more DPA servers are down.|
Fixed issues in Orion Platform 2017.3
|The global navigation menu bar is no longer missing.|
|1152162||Netpath can now access the requested path.|
|Netpath no longer times out and shows only a single point in time.|
|24135||A CPU utilization issue on multi-core nodes running Microsoft® Windows Server® 2008 R2 when using WMI or the agent polling method has been fixed.|
|1169799||Orion agent Debian-based Linux packages are no longer missing a space in the version information.|
|1152643||Agents that appear connected on the Manage Agents page can send information back to the server after an upgrade.|
|1081143, 1113910||Linux-based Orion agents no longer fill the /tmp folders with TaskProperties files.|
|1068885||The Orion agent can now differentiate between two nodes with the same IP address when one node is behind a NAT.|
|1053867||You can now add SNMPv3 credentials to poll a Windows node with the Orion agent.|
When deploying an Orion agent, the Application Event log no longer contains the following error:
|IPv6 nodes polled with ICMP are reachable and return correct values.|
|Incorrect time zone information for the southern hemisphere and the alerts are scheduled one hour earlier than intended.|
Repeated alert actions no longer stop working after one of the following occurs:
Login for domain users or groups added after an upgrade no longer fails with the following error:
1116840, 1113529, 1164723, 1195031, 1147707, 1130235,
|Repeated alert actions are now triggered as expected when an alert is edited or the alerting service is restarted.|
|The Node Reboot alerts and event-based alerts are now triggered as expected.|
|Scheduling for alerts and reports is no longer one hour off.|
Alert actions can be simulated and no longer return an error similar to the following:
1153845, 1134872, 1148761, 1154253, 1128086, 1158176, 1124099, 1060558
|The Orion Web Console is no longer slow after an upgrade due to SWIS v3 using a large amount of memory.|
|1180808, 1116741||Account limitations applied to groups no longer intermittently display unwanted nodes.|
|1094832, 1130773, 1159671, 1171385, 1171682, 1166910, 1116402||Resources with HEX-string values in the OIDs are now listed.|
|1139372, 1154482, 1156463, 1143611, 1118211, 1174841||Saved changes to Network Atlas maps are now displayed when your Orion server time zone is set to any negative time zone, such as UTC-5.|
|1126358, 1148560, 1144414, 1152358, 1159419, 1101641, 1118741, 1120297, 1107631, 1139310, 1130725, 1150164, 1175369, 1143012, 1155599||You are no longer prompted to log in when viewing reports. PDF reports no longer have a screenshot of the Orion Web Console login page or an Unexpected website error.|
|1148059, 1165475, 1166654, 1168955, 1171034, 1139724, 1156926, 1152091, 1148399, 1147728, 1146219, 1081084, 1148739||Performance issues due to deadlock and locking in the OrionServers table no longer occur.|
|1018994, 1084453, 1095223, 1113681, 1163514, 1083077, 1107391, 1123401, 1110556, 1130277, 1170228, 1033563, 1069910||Custom Object resources are no longer slow or time out when you edit or create them.|
|1163156||CPU is no longer high for trap services.|
|1142839||Page loading times are no longer high.|
|1103629, 1163273||You can now import custom properties for groups to a Worldmap.|
|1166215, 1166270||When integrated with ServiceNow instances with a large number of customizations, alerts now work as expected.|
|1165130, 1105005||Devices are now polled when you are missing SNMP v3 credentials.|
|1155215, 1155352, 1058519, 1096595, 1106405, 1089958, 1140354, 1138870, 1112997, 1132300||Automatic monitoring settings are no longer reset to the default after the Configuration Wizard runs.|
|1066550, 1100302, 1146412, 1124954||The Advanced Configuration page opens correctly.|
|1132857||When copying the default Node Details view, the Quality of Experience and Asset Inventory sub pages now copy the appropriate resources.|
|1136856, 1117267, 1116460, 1106393||SNMPv3 credentials are now correctly assigned to nodes.|
|1141314||The time is now updated in the Orion Web Console.|
|1136721||The Managed Alerts page does completely load, and you can filter alerts.|
|1132507, 1070372, 1056500, 1121349, 979463, 897210||Alerts created with a disabled user now work as expected, and the Active Alerts page is no longer blank or displaying an error.|
|1118106, 1141738||ServiceNow integration no longer stops working if you mass edit incidents.|
|1128614||You can now advance to the next Manage SNMPv3 credentials page.|
|1092013, 1097173, 1112369, 1117267, 1125348||SNMPv3 credentials are no longer deleted or incorrectly updated when you mass edit nodes that use different polling methods.|
|1100922, 1122034||An issue that prevented creating ServiceNow incidents due to missing roles has been fixed.|
|1106587||Limitations are now applied correctly to alerts.|
|1083182, 1142800, 1120175, 1118112, 1120175, 1109625||You can now add or search for domain accounts when using LDAP.|
|1110844, 1119752, 1100383, 1101723, 1112970||ServiceNow incidents no longer re-active.|
|1109266, 1072704, 1056235, 1052510, 1118865||Volumes added using WMI no longer stop polling.|
|1118901, 1076841, 1097612, 1089416, 1087776, 1024125, 968951||
Network Atlas maps no longer load slowly or not at all. You no longer receive an error similar to the following:
|1106647||Device type 184.108.40.206.220.127.116.11.1852 is now completely recognized.|
|1103781, 1097218, 1108197||
Some features, such as the Real-Time Process Explorer, no longer stop functioning when you additional polling engines with the following error:
|1102878, 1102634||The Settings page is no longer blank when the default document is disabled in IIS.|
|1100794, 1058790, 993082||The ServiceNow incident resource displays data.|
|1097774, 1054466||HTML reports are no longer embedded with What's New in the UI information.|
|705254, 993277, 1095107, 1081919, 1031691, 973096||When you monitor multi-core devices with WMI, the polled results are no longer inconsistent and do not return errors.|
The Orion Service Manager no longer opens with the following message:
|1086858||New Cisco switches (C 2990CX) no longer display an incorrect Machine Type.|
|1080095||The Custom Query resources does not page correctly.|
|1074893, 1044414, 1013808, 977233, 1059448, 1046813, 1027885, 940870, 1017984||You can now open Quality of Experience resources in the Orion Web Console or Network Atlas.|
|946894, 1018470||L3 polling data is no longer incorrect for some nodes.|
|869365, 1001732||The job engine for SNMP polling no longer becomes unresponsive and polling completes.|
|913105||Large spikes in the Data Transmitted metric on non-US English installations no longer occur.|
|818878||Trigger conditions no longer affect what is displayed in the Detected Objects window.|
|Some DPA data is not displayed correctly in PerfStack|
|Issue: DPA data that represents a time series and can include multiple metrics is not displayed correctly in PerfStack charts. What should be shown as stacked graphs is displayed as a single line.|
|Date range is one day behind on Wait Time resources|
Issue: The date on Wait Time Trends resources is one day behind for environments where the DPA and Orion servers are in different time zones. The affected resources are:
|Resolution/Work-around:Set the DPA and Orion servers to the same time zone.|
|DPAIM stops working after failover|
|Issue: If you have High Availability configured, the DPA Integration Module stops working when a failover occurs after you re-integrate with a previously integrated DPA server.|
|Resolution/Work-around: Re-integrate the DPA server.|
|Cannot integrate DPA servers when the Orion Platform uses Windows Authentication|
Issue: When the Orion Platform uses Windows authentication to access the Orion database, attempts to integrate a DPA server fail with the following error:
|Resolution/Work-around: Configure the Orion Platform to use a SQL Server account to access the Orion database. To do so, run the configuration wizard and specify that you want to update only the database.|
|Report resource fails to initialize if any DPA server is down|
Issue: If you attempt to create or run a report that includes DPA resources and any integrated DPA server is down, the following error is returned:
|Resolution/Work-around: To avoid this error, ensure that all integrated servers are up before creating or running reports that include information from DPA. Alternatively, remove the integration for a server and reintegrate it later.|
|Database instance limitations do not work properly with groups|
|Issue: If there are limitations on a user account to prevent the user from viewing information about certain database instances, and a group includes database instances that match the limitations, the limitations have no effect. When the user accesses the group, the user can see information about all database instances despite the limitations.|
|Resolution/Work-around: Be aware of this issue when you are setting up security.|
© 2017 SolarWinds Worldwide, LLC. All rights reserved.
This document may not be reproduced by any means nor modified, decompiled, disassembled, published or distributed, in whole or in part, or translated to any electronic medium or other means without the prior written consent of SolarWinds. All right, title, and interest in and to the software, services, and documentation are and shall remain the exclusive property of SolarWinds, its affiliates, and/or its respective licensors.
SOLARWINDS DISCLAIMS ALL WARRANTIES, CONDITIONS, OR OTHER TERMS, EXPRESS OR IMPLIED, STATUTORY OR OTHERWISE, ON THE DOCUMENTATION, INCLUDING WITHOUT LIMITATION NONINFRINGEMENT, ACCURACY, COMPLETENESS, OR USEFULNESS OF ANY INFORMATION CONTAINED HEREIN. IN NO EVENT SHALL SOLARWINDS, ITS SUPPLIERS, NOR ITS LICENSORS BE LIABLE FOR ANY DAMAGES, WHETHER ARISING IN TORT, CONTRACT OR ANY OTHER LEGAL THEORY, EVEN IF SOLARWINDS HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.
The SolarWinds, SolarWinds & Design, Orion, and THWACK trademarks are the exclusive property of SolarWinds Worldwide, LLC or its affiliates, are registered with the U.S. Patent and Trademark Office, and may be registered or pending registration in other countries. All other SolarWinds trademarks, service marks, and logos may be common law marks or are registered or pending registration. All other trademarks mentioned herein are used for identification purposes only and are trademarks of (and may be registered trademarks) of their respective companies.