View MSSQLServer metrics using stored procedure

[Klaus Lintz]

Hi Team

We have a requirement to query a database table to return a single value using a stored procedure.

We have on-prem installation version 23.1

Below is the only documentation I could find

SQL Server Monitoring Metrics

Broadcom		remove preview
SQL Server Monitoring Metrics This section lists all the metrics for the respective Monitored Groups that you can collect using SQL Server in the In the , the SQL Server instance is displayed under the folder, *SuperDomain*||Infrastructure|Agent|SQL Server Databases| | as follows: SQL Server Cluster Metrics To view the SQL Server Cluster metrics, you need to enable the SQL Cluster Metrics in DX APM. View this on Broadcom >

Your assistance will be appreciated

Klaus

[Harold Martin]

Hello Klaus,

I think you need to develop a script in perl, php or java to execute the query (stored procedure) and upload it using an EPAgent.

Two options are for this too: to contact Broadcom services or to develop it internally.  third option: a third party ;)

regards,

Harold

------------------------------
Harold Martin
Senior Consultant
------------------------------