Seeing some non-integer values for custom metrics that should return integers.

HenryT · May 21, 2024 6:28PM

Playing with the new restAPI and I am looking at results for the "Number of unused indexes"

and seeing data like this, the query should (and I suspect is) return integer values. Why am I getting this?

     {
          "dateTime": "2024-05-21T17:26:51.8380771Z",
          "value": 0.00718123376274544
        },
        {
          "dateTime": "2024-05-21T17:36:51.8238908Z",
          "value": 0.0010450247083899555
        },
        {

Alex B · May 23, 2024 7:34AM

Hi @HenryT,

To confirm, is it this custom metric https://sqlmonitormetrics.red-gate.com/number-of-unused-indexes/?

Have you accidentally changed it to record the rate of change (is this box checked)?

Image: https://redgatesupport.zendesk.com/attachments/token/CyieJ1LoV9s1K7026vdCkkzdc/?name=image.png

If you go to the Analysis page and select that custom metric do you see integers or decimals?

Also, what specific API request did you use (just to check it's looking at the metric you believe it is)?

Kind regards,
Alex

HenryT · May 23, 2024 1:56PM

I do not have rate of change checked.

The configuration of the metric, it is out of the box.

Image: https://us.v-cdn.net/6029854/uploads/editor/1m/70we5sk6o0d8.png

Image: https://us.v-cdn.net/6029854/uploads/editor/ks/wmzk4op9ky0t.png

Here is the obfuscated call.

http://xxx-xxxxx:8080/api/v1/metrics?metricTypeId=[Cluster].[SqlServer].[Database].[CustomMetric].%5xxxx-xxxx.xx.xxx.com:2]

Alex B · May 23, 2024 3:29PM

Hi @HenryT,

Chatting to the team, specific support for Custom metrics wasn't included in the release. What is the bit obfuscated at the end of the call - an entity name or the base monitor name or something else?

Do you have more than one custom metric added?

Kind regards,
Alex

HenryT · May 23, 2024 5:12PM

Yes

HenryT · May 23, 2024 5:13PM

For what it is worth, the custom metrics do show up when you call type types method.

Alex B · May 28, 2024 2:49PM

Hi @HenryT,

I've mentioned that they exist to the developers. Looking at the information for what is returned for me, it looks like the last part is the Base Monitor name and then the custom metric ID from settings.customMetrics separated by a colon:

    {
      "id": "[Cluster].[SqlServer].[Database].[CustomMetric].[localhost:20]",
      "name": "Number of unused indexes",
      "category": "localhost Custom metrics"
    }

Image: https://redgatesupport.zendesk.com/attachments/token/MqBtyvwD2L7CQaXcBpuEyCGNm/?name=image.png

And if I then look to get that information from the API it shows the correct info (19):

Image: https://redgatesupport.zendesk.com/attachments/token/oJeytF0YMZCOE1a8A2lATKdWK/?name=image.png

which is the same as what I see on the Analysis page for the metric:

Image: https://redgatesupport.zendesk.com/attachments/token/2xCsvKgAJEKd3G3BBOZ5qUi4h/?name=image.png

With that all said, are you looking at the correct custom metric endpoint (you showed custom metric ID=2 in the URL you linked before)? Does the data on the Analysis graph correlate wtih what the metric is returning?

Kind regards,
Alex

HenryT · May 28, 2024 4:11PM

Some more detail, and this may be in part a user error by me, but it doesn't seem very clear.,

The metric looks fine in analysis.

I have three monitors in three locations, but this custom alert is only defined in one location—it is not the primary location.

I do a call to http://MyWebInstance:8080/api/v1/metrics/types and I see the following containing 'Number of unused indexes'.

I have three monitors, but only one has this metric.

{

"id": "[Cluster].[SqlServer].[Database].[CustomMetric].[MyNonPrimaryMonitorInstance:2]",