The following notes describe 4.5.x updates to AppDynamics Database Visibility, which gives you end-to-end visibility on the performance of your database.
If an artifact has been updated, the version number of the updated artifact and its availability date are listed below. The version number corresponds to that shown on the download portal (http://download.appdynamics.com).
The most recent releases appear at the top of the page.
4.5.15 Updates
October 17, 2019
Enhancements
- Controllers now support Total Lock Time (total time for which the database is in the lock state in seconds) which is an Additional Metric Support in Metric Browser. The supportable databases are DB2/MS-SQL/Sybase ASE/Oracle.
4.5.14 Updates
September 20, 2019
Enhancements
- You can now view the DTU metrics for Azure using DTU Utilisation chart available on the dashboard.
4.5.13 Updates
August 23, 2019
Resolved Issues
Key | Summary |
|---|---|
| DBMON-5300 | SSL error is displayed when connecting to Oracle Cluster with the TNS style connection url |
| DBMON-5112 | User with view permissions to Collector and Database application is unable to view custom metric tab data but able to view the custom metric data when using metric browser |
| DBMON-5385 | Object browser does not work when connection parameter is set through a Custom JDBC Connection String |
| DBMON-5347 | Unable to monitor Sybase database when Db-agent sends more than 23-character application name to the database |
| DBMON-5549 | WaitStates Info shows "No data to display"on Query Details Page for 4.5.13 Controller |
4.5.12 Updates
July 18, 2019
Resolved Issues
Key | Summary |
|---|---|
| DBMON-5012 | Upgraded the logger version to avoid occasional deadlocks |
| DBMON-5079 | DBAgent throws errors when trying to capture CPU metrics |
| DBMON-4915 | Fixes PostgreSQL DB version detection for unexpected values |
| DBMON-4995 | Intermittent Controller connection issue happens inside DB Agent |
4.5.11 Updates
June 20, 2019
Enhancements
- Snapshot correlation is now available for .NET applications and their relational database backends.
Resolved Issues
Key | Summary |
|---|---|
| DBMON-5020 | MongoDB nodes stop with "server session pool is open" error until Database Agent is restarted |
| DBMON-5014 | MongoDB agent stops working when hardware monitoring is enabled |
| DBMON-4967 | Conflicts occur with Oracle driver 7 when trying to connect with Oracle db |
4.5.10 Updates
May 16, 2019
Enhancements
- The Database agent collects query stats if pg_stat_statement module is installed in PostgreSQL database version 9.0 and above.
Resolved Issues
Key | Summary |
|---|---|
| DBMON-4820 | Blocking sessions feature does not work with the dbagent.use.snap.view.for.monitoring=true system property to run Snapshot queries for db2 v9.7 or above collectors |
| DBMON-4567 | Search in Database Agents tab should be case-insensitive |
Known Issues
Key | Summary |
|---|---|
| DBMON-5020 | MongoDB nodes stop with "server session pool is open" error until Database Agent is restarted |
4.5.9 Updates
April 18, 2019
Enhancements
- You can now view query and block duration details of a session under Blocking Sessions > Session Details.
- For a Couchbase collector, you can view the names of the top 200 buckets and statistics through the newly added Buckets Window. See Database Buckets Window for details.
Resolved Issues
Key | Summary |
|---|---|
| DBMON-4631 | Database agent gets stuck when new collectors are added to an agent as child processes expand in number |
4.5.8 Updates
March 25, 2019
Enhancements
You can add a new JDBC connection property or edit an existing property for databases using Connection Properties option added to the Create New Collector window. You can choose to show or hide the value of a JDBC connection property. The Connection Properties field is enabled for all relational databases and disabled for Couchbase and MongoDB. See Database Collectors.
Resolved Issues
Key | Summary |
|---|---|
| DBMON-4434 | Silent mode installation for db-agent windows service |
4.5.7 Updates
Version 4.5.7.1127 – February 21, 2019
Enhancements
- Azure SQL Managed Instance is a supported platform for AppDynamics Database Visibility.
- Configure Microsoft SQL Server Collectors to monitor an Azure SQL Managed Instance and collect all the supported information. You can view all the events related to Azure SQL Managed Instance and SQL-specific features in Azure SQL. See Configure Microsoft SQL Server Collectors
Resolved Issues
Key | Summary |
|---|---|
| DBMON-4396 | Query statistics spike once every 12 hours for DB2, SQL Server, and Oracle with database agent versions above 4.4.4 |
| DBMON-4206 | Database Agent is visible in the Controller UI even after the process is killed |
4.5.6 Updates
Version 4.5.6.1024 – January 23, 2019
Enhancements
- The Database Visibility Dashboard introduces an Applications tab that lists out applications and the time spent by an application on MongoDB 3.4 and above. See Database Applications Window.
Resolved Issues
Key | Summary |
|---|---|
DBMON-3971 | Test Query is disabled by default on the Create Custom Metric window |
| DBMON-4297 | No data found on the Custom Dashboard for PostgreSQL Server Statistics metrics |
| DBMON-4327 | When a deep link URL is shared, Custom Dashboard with Analytics Widget fails to authenticate the user |
4.5.5 Updates
Version 4.5.5.985 – November 29, 2018
Enhancements
- You can now test the results of a Custom Metric query using the Test Query in the Custom Metric Creation dialog.
Resolved Issues
| Key | Summary |
|---|---|
| DBMON-3969 | Error in UI while saving custom metric in Database monitoring, available/selected databases list for "these specific databases" is empty |
| DBMON‑4217 | Compatibility between DB Agent pre-4.3.4 and controller post-4.5.2 is broken |
| DBMON-4239 | Data collector for Mongo database does not collect information; log displays class cast exception |
4.5.4 Updates
November 20, 2018
Enhancements
- The following MongoDB metrics are now supported:
- Replication_MyState
- OplogTimeDiff_in_sec
- Oplog_Size
Oplog_Max_Size
- The following REST call allows you to get a list of monitored database servers: GET /controller/rest/databases/servers. For more information, see Database Visibility API.
- The Database Visibility artifact now includes a script that you can run to install the Database Agent as a Windows Service. For more information, see Install the Database Agent as a Windows Service.
Resolved Issues
| Key | Summary |
|---|---|
| DBMON‑3382 | REST API rest/databases/collectors returns licensesUsed=0 |
| DBMON-3236 | Hardware statistics on memory used for Oracle database server are not reported |
| DBMON-4112 | Fields in "Select" statements for creating custom metrics cannot contain HTML or special characters |
| DBMON-4052 | Custom Events are being generated from empty result sets |
4.5.2 Updates
Version 4.5.2.818 – September 27, 2018
Enhancements
- The secure credential store utility file (scs-api.jar) is now replaced with scs-tool.jar.
Resolved Issues
| Key | Summary |
|---|---|
| DBMON‑3376 | Downloaded SQL plan is not valid XML |
| DBMON-3397 | 'CONCAT' is not a recognized built-in function name for MSSQL |
| DBMON-3856 | Credential encryption utility jar missing in dbagent latest version |
| DBMON-3895 | Each Couchbase collector should consume one license per node |
4.5.1 Updates
Version 4.5.1.732 – September 5, 2018
Resolved Issues
| Key | Summary |
|---|---|
| DBMON‑3143 | The value of Storage on DB server and the value of Storage at ObjectBrowser do not match and displays zero in UI |
| DBMON-3371 | Controller upgrade to 4.5 fails on DBMON schema migration when there is no internet connection |
4.5.0 Updates
July 11, 2018
Enhancements
- Couchbase monitoring is now supported.
- Custom query metric improvements: you can specify a custom query that you want Database Visibility to issue at regular intervals. The results are collected in a custom metric.
- Parameter change tracking enhancement: you can view the changes to database configuration parameters over time.
- Export collectors enhancement: you can export database collector data into a CSV file.
- Snapshot correlation enhancement: you can view the queries that were issued by each business transaction.
- Generic Cluster Support: better support for groups of databases, or database clusters, including primary/replica, and other replication technologies as well as sharded architectures. AppDynamics Database Visibility now allows you to group configurations under a single Collector, providing enhanced configuration and visualization within the UI.
Resolved Issues
| Key | Summary |
|---|---|
| DBMON-2943 | Posgres Collector is unable to navigate to databases section from Object Browser |
| DBMON-2953 | DB Agent 4.4.2 fails to start with SQL Server collector when Windows authentication is enabled |
| DBMON‑2977 | MSSQL Collector stops reporting data after 9 minutes |
| DBMON-3068 | Getting permission exception while exporting grid data on the query detail page. |