Custom Metric for SQL Code Analysis Issues

jgraves

Is it possible to write a custom metric for SQL Code Analysis issues found? We think this would be a great metric to track over time - with a graph going down to the right being a very good sign!

Thoughts appreciated.

Thanks, Jay

Russell D

If you can work out how to get a numeric value out of it this could be feasible - the only requirement is that its a single, numeric or null value: https://documentation.red-gate.com/sm9/configuring-sql-monitor/creating-custom-metrics-and-alerts/step-1-define-metric.

jgraves

Russell D said:

If you can work out how to get a numeric value out of it this could be feasible - the only requirement is that its a single, numeric or null value: https://documentation.red-gate.com/sm9/configuring-sql-monitor/creating-custom-metrics-and-alerts/step-1-define-metric.

Do you know if it is a metric that SQL Monitor makes available for use?

Russell D

No I'm afraid there's no such provision within Monitor.