I'd like to see the differences between those two solutions. I need to store and analyze ADF metadata and SQL Database metadata. Like pipeline errors, pipeline duration, pipeline parameters, sql table inserted, deleted records.
I'm testing Log Analytics and have some questions:
Azure Data Factory Analytics/Azure SQL Database Analytics.
- Are they just ready charts based on Log Analytics?
- Is that mean that they are free and there are only costs for Log Analytics?
- Am I able to create the same charts based on Log Analytics without ADF Analytics and SQL Analytics?
Log Analytics:
- How many days data logs are available there? How I can check it?
- In which way I can store logs and have an access after that period? If I will archive them in the storage account can I make queries on them in the Azure Monitor?
- There are a lot of sample kusto queries to monitor for example errors in the SQL database.
They are based on table AzureMetrics but I don't have access to it. Do you know how to add it? - What's the difference between sending logs to Log Analytics to AzureDiagnostic and ResourceSpecific?
- If you know about some interesting articles/best practices to store Azure metadata (ADF, Databrick, SQL Managed Instance) it will be great if you can post it.
Thanks in advance.
