How to optimize queries in Azure Monitor logs

%3CLINGO-SUB%20id%3D%22lingo-sub-2459933%22%20slang%3D%22en-US%22%3EHow%20to%20optimize%20queries%20in%20Azure%20Monitor%20logs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2459933%22%20slang%3D%22en-US%22%3E%3CP%3EHave%20you%20ever%20considered%20improving%20the%20performance%20of%20your%20queries%20in%20Azure%20Monitor%20Logs%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20are%20some%20cases%20where%20you%20can%20dramatically%20improve%20your%20query%20performance%20with%20some%20small%20changes%20to%20the%20operators%2Ffunctions%20used%20and%20the%20order%20of%20operations.%20This%20video%20explains%20performance%20considerations%20in%20Azure%20Monitor%20Logs%20and%20shows%20several%20techniques%20for%20improving%20query%20performance%20and%20reducing%20run%20times.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%20%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMore%20details%20available%20in%20documentation%3A%26nbsp%3B%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fazure-monitor%2Flogs%2Fquery-optimization%22%20rel%3D%22noopener%20noreferrer%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fazure-monitor%2Flogs%2Fquery-optimization%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20to%26nbsp%3B%26nbsp%3Band%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2459933%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDiagnostic%20Logs%20%26amp%3B%20settings%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELog%20Analytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EQuery%20Language%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2705062%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20optimize%20queries%20in%20Azure%20Monitor%20logs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2705062%22%20slang%3D%22en-US%22%3EGet%20the%20**bleep**%20out%20of%20my%20account%3C%2FLINGO-BODY%3E
Microsoft

Have you ever considered improving the performance of your queries in Azure Monitor Logs?

 

There are some cases where you can dramatically improve your query performance with some small changes to the operators/functions used and the order of operations. This video explains performance considerations in Azure Monitor Logs and shows several techniques for improving query performance and reducing run times.

 

 

More details available in documentation: 
https://docs.microsoft.com/azure/azure-monitor/logs/query-optimization 

Thanks to @Meir Mendelovich and @Antonio Di Lorenzo 

0 Replies