custom metric - caluclated rate of change display problem
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?