Open for Voting

Prometheus Query Component

I would like to see the ability to query a Prometheus database from a SAM component.  

https://prometheus.io/

We have a couple of application stacks that are sending custom performance metrics and would like to have a more seamless integration into Solarwinds.  Currently, we are using Grafana to visualize and alert on these metrics but it would be a "nice to have" if we could cut out the middle man and poll the datasource directly.

  •  

    Here are a few examples I use:

    Measuring an increase over a five minute span.  

    /api/v1/query?query=increase(<some metric>{cluster=~"<some cluster name>"}[5m])

    This one will give you a per second rate over a five minute period.

    /api/v1/query?query=rate(<some metric>[5m])

    Depending on the metric, you can also grab multiple objects in one call and separate them out.  You'd just have to be aware if/when objects show up or get removed.

    /api/v1/query?query=sum by (<some label>) rate(<some metric>[5m])

    Hope that helps some! 

  •  

    This is perfect! Well.. kind of. It looks like it doesn't auto-add new objects, but it's definitely a start. 

    Would you be willing to share your API query? right now I'm just looking at the example ( /api/v1/query?query=up) and I'm wondering if there is a way to pull out specific data. My integrations team mostly needs to track failed exchanges. 

  • A little update on this:

    I've started using the new SAM API poller to query the Prometheus API directly.  While there are limits to how many metrics I can collect, it's definitely a move in the right direction. :smileylol:

  • Our WEB folks bought AppOptics a while back and have been using it to monitor our main websites and a few vital things we have here and there. They are using PHP and NGINX, so the integration isn't terribly useful for us at the moment, but I'm quite looking forward to the integration being expanded. We were planning on using AppOptics to meta-monitor our local Orion instance, so we'd know if the server had issues, but I have to make the case to my higher-ups about the Return on investment for such a setup as the next AppOptics tier for us is quite a bit higher.

    That said, my goal is to convince our management that Orion should be our single pane of glass, and our other apps flow off of it. and AppOptics is part of that.

    We have a couple things that use Prometheus - our Java developers are using it for integrations in our OpenShift stack, and we have a local GitLab instance that acts as our CI/CD backend and a few other functions.

  • ahbrook  wrote:

    It looks like the AppOptics is working towards Prometheus integrations, which is awesome.

    https://docs.appoptics.com/kb/host_infrastructure/integrations/tested/prometheus/

    However, right now the only Orion and AppOptics integration is for IIS. While it might cost us a little more, if push comes to shove having AppOptics collect the data and display it in Orion would meet our needs.

    Tony, that's great feedback. Do you currently have AppOptics and SAM already?