Why are few database metrics in the Database tab showing empty values in MS SQL monitor?
Why are few database metrics in Database tab showing empty values in MS SQL monitor?
Before Applications Manager version 13910, We were showing high-level metrics for MS SQL monitor's Database usage from SQL server performance counters.
But from Applications Manager version 13910, We are showing detailed usage of Data files & Log files(Database Disk Utilization), VLF Details, DBCC Information, Mirroring Details which requires connection with each database present in the SQL server with db_datareader permission. Please refer 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 execute the data collection query then the particular database metrics will be shown as empty in Database page.
This issue will be solved by giving proper permission on each database
How to switch to Old view of Database page?
In case you are in latest version (above 13900) and you dont want to provide db_datareader permission for each database then you can switch back to the old view by enabling the below key. Connect to Applications Manager backend database and execute the below query.
UPDATE AM_GlobalConfig SET VALUE='true' WHERE NAME='updateOldVersionModelForMSSQLDBDetails'
Restart the build and check the Database tab.
If you switch back to old UI then you will not be able to monitor the metrics of individual Data files & Log files(Database Disk Utilization), VLF Details, DBCC Information, Mirroring Details.
Why are thresholds and alerts not working in Database tab metrics of MS SQL monitor?
In Applications Manager's MS SQL monitor, metrics under Database tab are collected once in an hour by default. Therefore, under Admin -> Performance polling -> MS SQL -> Database Metrics, the option 'Collect SQL Database metrics once in an hour' is ...
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 ...
How is Backup Age calculated for MS SQL DB monitor?
Backup Age displays the number of hours passed since the backup operation was completed. In simple terms, it is the difference between the current time and the time at which backup was performed. Backup Age (hours) = Current Time - Backup Time By ...
No data available in 'Availability Groups' table under 'AlwaysOn Availability Groups' tab in MS SQL monitor
Solution: Check whether 'VIEW ANY DEFINITION' permission is given to monitor AlwaysOn Availability Groups. To do so, follow the steps given below: Connect AlwaysOn enabled server in SQL Server Management Studio with the username which is used to ...
Troubleshooting MS SQL login failure
Problem: The following error message appears in MS SQL monitor during login: "Login Failed. The login is from an untrusted domain and cannot be used with Windows authentication" Solution: Verify if the password of the SQL account (domain\username) ...