custom metric - caluclated rate of change display problem

j_granden

I've got a custom metric to capture requests/sec for a workload group:

SELECT total_request_count FROM sys.dm_resource_governor_workload_groups WHERE name = 'MyGroup'

I've got the "Use a calculated rate of change between collections" checkbox checked.

This works great, except when the sql instance restarts, and the total_request_count gets reset to zero. This shows up on the graph as a huge negative number, skewing the rest of the graph to be unusable. (all the detail gets squished to a flat line)

Is there a way to make the graph not display large negative numbers?

thanks

Alex B

Hi j_granden,

Unfortunately there is not a way to change the graph to handle the large spikes in data (either positive or negative). Please vote on this uservoice which is related to this issue.

Kind regards,
Alex