Search code examples
azureazure-log-analyticsazure-monitoring

Is Azure Monitor a good store for custom application performance monitoring

We have legacy applications that currently write out various run time metrics (SQL calls run time, api / http request run times etc) to local SQL DB.

format:( source, event, data, executionduration)

We are moving away from storing those in local SQL DB, and are now publishing those same metrics to azure event hub.

Looking for a good place to store those metrics for the purpose of monitoring the health of the application. Simple solution would be to store in some DB and build custom application to visualize the data in custom ways.

We are also considering using Azure Monitor for this purpose via data collector API (https://learn.microsoft.com/en-us/azure/azure-monitor/platform/data-collector-api)

QUESTION: Are there any issues with azure monitor that would prevent us from achieving this type of health monitoring?

Details

  • each event is small (few hundred characters)
  • expecting ~ 10 million events per day
  • retention of 1-2 days is enough
  • ability to aggregate old events per source per event is important (to have historical run time information)

Thank you

Solution

  • You can do some simple graphs and with the Log Analytics query language, you can do just about any form of data analytics you need.

    Here's a pretty good article on Monitor Visualizations.

    learn.microsoft.com/en-us/azure/azure-monitor/log-query/charts