Why don't I don't see any metrics under database tab ?
- You might have disabled SQL Query listening in your Agent. Enable it by setting true for the below key.
Name | Key | Description | Default value |
Capture Database SQL Queries | sql.capture.enabled | Enabling this option will help listen to all the SQL Queries that get executed. If it is disabled, no Database Metrics will be collected. | True |
To access the Enable option go to Settings → Discovery & Data Collection → APM Insight Agent Configuration Profile → <Your-APM-Insight-Monitors-Associated-profile>
- Check if the database used is supported for respective agents.
- Check if you are using any wrapper around the JDBC client and if the database calls are initiated from the same application server where the APM Insight agent is installed.
New to ADSelfService Plus?
Related Articles
Why are some metrics in the Database tab of the MS SQL monitor showing empty values?
Before Applications Manager version 13910, we displayed high-level metrics for the MS SQL monitor’s database usage using SQL Server performance counters. From version 13910 onwards, we fetch detailed database-level metrics. As a result, some metrics ...Why are thresholds and alerts not working for metrics in the Database tab of the MS SQL monitor?
By default, Applications Manager collects metrics under the Database tab of the MS SQL monitor once every hour. The Collect data control this behavior in every hour option under: Settings → Performance Polling → MS SQL → Metric Name: Database Since ...Integrating Applications Manager backend Microsoft SQL database with Power BI Desktop
Overview This KB provides step-by-step instructions to connect Power BI Desktop to your Applications Manager's Microsoft SQL backend database, enabling you to create custom reports and dashboards using Applications Manager's performance metrics and ...WMI Metrics Reference Tables
Windows Server Monitor - WMI Metrics Reference Tables This document lists the WMI namespaces, classes, and WQL queries used by AppManager Windows Server Monitor scripts in WMI mode. These reference tables can be used for troubleshooting WMI-related ...Troubleshooting Mailbox and Database Statistics Data Collection
In an Exchange Server monitor added in PowerShell mode, if performance metrics are visible but Mailbox and Database Statistics data is not collected, the issue might be that the normal PowerShell session is working fine, but the Exchange PS Session ...