We have experienced the Historical Metric Clamp a few times now. I have cleaned some up, as well as increasing our clamp limit.
But my ultimate question is why do I see a "Number of Historical Metrics" of over 1.5 million, and a "Number of Metrics" of only 192 K.
If this means I have 1.3 million historical metrics I can delete, how do I figure that out? I did a SmartStorTools "test-regex", and that seems to list listed out a little over 1 million metrics (with over 800 K being backend metrics - I can see one of our teams is somehow generating a ton of similar but slightly different SQL statements).