That's not currently possible with custom metrics. The T-SQL on which the custom metric is based must return a single, numeric scalar or NULL value. It can call a stored procedure, as long as the returned value meets the same criteria. It cannot collect multiple values, results containing alphabetic or special characters, or recordsets.
Comments
That's not currently possible with custom metrics. The T-SQL on which the custom metric is based must return a single, numeric scalar or NULL value. It can call a stored procedure, as long as the returned value meets the same criteria. It cannot collect multiple values, results containing alphabetic or special characters, or recordsets.
https://documentation.red-gate.com/disp ... ine+metric
Hope that helps.
Thanks
Adam