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 thresholds and alerts not working in Database tab metrics of MS SQL monitor?
In Applications Manager's MS SQL monitor, metrics under the Database tab are collected once every hour by default. This is controlled by the 'Collect data in every hour' option under Settings → Performance Polling → MS SQL → Metric Name: Database, ...Why are a few database metrics in the Database tab showing empty values in the MS SQL monitor?
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 ...Resolving no data error for MSSQL performance metrics
Problem: If the metrics in the MS SQL monitor's 'Overview' page isn't getting populated, it might be due to any of the following reasons: - MSSQL user does not have permission to access the performance counters. - Data collected from SQL server is ...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 ...Azure SQL Database - FAQ
1. Why have we removed the Diagnostic Settings dependency in Azure SQL Database monitor? Till APM v15240: Azure SQL Database was using Diagnostic Settings to perform data collection. Prerequisites had to be fulfilled to turn on Diagnostic Settings ...