What database is used in Azure Application Insights?

Question

I read the Application Insights Analytics ("Kusto") analytics description and I asked myself which database systems they use. Does anyone know this?

https://blogs.msdn.microsoft.com/bharry/2016/03/28/introducing-application-analytics/

A blog post indicates an incredible amount of data and very good query performance. As a computer science guy, I would like to know what technology is being used. I don't think this is a secret, so maybe a Microsoft employee could answer it?

Answer 1

I have no evidence for this answer, it's just my own suspicions.

Given the price point of Application Insights and the huge amount of data that it can swallow, I would be very surprised if it were SQL / DocumentDB, etc. Most likely, this is Azure Storage Tables.

I would suggest that the architecture is the storage account in your subscription, and the Azure server cluster uses the data and spills it into your table. Then, when you read this data, it converts the queries into a format that storage tables can use.

This is the only architecture that I see that will make it profitable to deploy, although there is probably an added value, people will use Application Insights because they already use other Azure Services.

In any case, this will be my hypothesis, and if we do not get the Azure Dev response, it is probably as good as we get.

Answer 2

According to this article , telemetry data collected from your application is stored and analyzed directly on the Azure Portal, you can export data to SQL, Power BI or your own tools. But there seems to be no official docs about the database system.