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 may show empty values if the required data is not available from the SQL Server.
But from Applications Manager version 13910, we display the detailed usage of data files and log files (Database Disk Utilization), VLF details, DBCC information, and mirroring details. This requires a connection to each database present in the SQL Server with db_datareader permission.
Please refer to our
prerequisites link regarding permissions. In case the SQL user used for monitoring doesn't have the mentioned permission — either to connect to the respective database or to execute the data collection query—then the particular database metrics will be shown as empty on the Database page.
If you are on the latest version (above 13900) and do not wish to provide db_datareader permission for each database, you can revert to the old view by enabling the Disable connections to database(s) checkbox available under:

Settings → Performance Polling → MS SQL → Database → Disable connections to database(s)
How to switch to the old view of the Database tab?
If you're using a version above 13900 and do not wish to provide db_datareader permission for each database, you can switch back to the old view by enabling the configuration key directly in the backend database. To do this:
- Connect to the Applications Manager backend database.
- Execute the following query:

UPDATE AM_GlobalConfig SET VALUE='true' WHERE NAME='updateOldVersionModelForMSSQLDBDetails';
- Restart the Applications Manager service.
- Check the Database tab in the MS SQL monitor to confirm the change.

Note: If you switch back to the old UI, you will no longer be able to monitor the following metrics:
- Individual Data files & Log files (Database Disk Utilization)
- VLF (Virtual Log File) Details
- DBCC (Database Console Command) Information
- Mirroring Details
These metrics are available only in the latest version that connects to each database individually.