1) Add a new metric for Database agent. Please follow below steps
- Goto 'Database' Dashboard---> select and click on 'Database instance'
- Click on 'SQL PI' ----> Select the 'database instance' want to add metric, click on 'Select Metric'
- After adding click on 'Apply' and 'Ok'
2) Run the script attached(updatePASSVisibleStats_v2) in script console. Below are the steps
- Administration---->Tooling---->Script Console
- Select 'Scripts' tab and click on 'Add' It pop-up 'Run Script' page and copy the script from updatePASSVisibleStats_v2.txt and click on 'Run'
This issue was logged as defect FOG-5132 and has been fixed in the 6.3 and higher releases of Foglight.