Open for Voting

Custom Metric - Allow Multiple Value Returns

The ability to add custom metrics not limited by "The query must return a positive numeric value and only 1 row and 1 column" would be a great addition.

The ability to return multiple values with a key value as a set would extend the functionality. Obvious example would be to create custom metrics to return information at individual database level (size, % used etc) for all databases in a single metric. These could then be displayed in DPA in a single chart, or split by the key value across several charts grouped in a DPA category.

There would probably have to be some kind of upper limit or warning on the number of rows returned by the metric to stop things getting out of hand if misused, and it would need to handle key values potentially changing over time (in example usage as new databases added or old databases removed).

Thanks

(apologies if this is a duplicate request - I had a quick look round and couldn't find a version of it)