APMIA MSSQL Extension Metrics Requirements

Products

• CA Application Performance Management SaaS

Issue/Introduction

One of our DB team is looking for few new metrics which are listed below in MSSQL DB extension.

 

• Index Fragmentation Status under “Index Statistics”
• Listener information (name. host, status, etc)
• Database/s included on an availability group

Let me know if these can be enabled through properties or we need enhancement.

Environment

Release : SAAS

Component :

Resolution

Issue 1: Original Ask:

One of our DB team is looking for few new metrics which are listed below in MSSQL DB extension.

Index Fragmentation Status under “Index Statistics”
Listener information (name. host, status, etc)
Database/s included on an availability group
Let me know if these can be enabled through properties or we need an enhancement.

I responded with please review the metrics 

in https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/dx-apm-agents/apmtest/infrastructure-agent/MS-SQL-Database-Monitoring/SQL-Server-Monitoring-Metrics.html

Your response is 

The metrics are mentioned in the below document is not appearing in APM. That metric is acceptable once available in APM.

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/dx-apm-agents/apmtest/infrastructure-agent/MS-SQL-Database-Monitoring/SQL-Server-Monitoring-Metrics.html

If the metrics in the link are acceptable but not appearing on a working agent AND enabled. That is a new case . I will open a new case 33177615 to document this issue. and then close You can open another case referring to this new case with Agent config files, screenshots and logs when ready.