custom metric - caluclated rate of change display problem

j_grandenj_granden Posts: 2
edited May 24, 2016 8:55PM in SQL Monitor Previous Versions
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

Comments

Sign In or Register to comment.