SOLVED

Measuring Memory Percentage in SQL Managed Instances using Log Analytics

%3CLINGO-SUB%20id%3D%22lingo-sub-903991%22%20slang%3D%22en-US%22%3EMeasuring%20Memory%20Percentage%20in%20SQL%20Managed%20Instances%20using%20Log%20Analytics%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-903991%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20it%20possible%20to%20measure%26nbsp%3BMemory%20Percentage%20in%20SQL%20Managed%20Instances%20using%20Log%20Analytics%20(Azure%20SQL%20Analytics).%20I%20am%20only%20able%20to%20see%20CPU%2C%20Storage%20and%20IOPS%20in%20Azure%20SQL%20Analytics%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20it%20is%20not%20a%20part%20of%20SQL%20Analytics%2C%20how%20must%20we%20configure%20alerts%20based%20on%20high%20memory%20usage%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20feedback%20is%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-903991%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EApplication%20Insights%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAzure%20Log%20Analytics%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-904617%22%20slang%3D%22en-US%22%3ERe%3A%20Measuring%20Memory%20Percentage%20in%20SQL%20Managed%20Instances%20using%20Log%20Analytics%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-904617%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F423172%22%20target%3D%22_blank%22%3E%40karthiksubramanians%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENo%20this%20is%20not%20possible%20as%20there%20isn't%20such%20metric%20per%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-monitor%2Fplatform%2Fmetrics-supported%23microsoftsqlmanagedinstances%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-monitor%2Fplatform%2Fmetrics-supported%23microsoftsqlmanagedinstances%3C%2FA%3E%20.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Is it possible to measure Memory Percentage in SQL Managed Instances using Log Analytics (Azure SQL Analytics). I am only able to see CPU, Storage and IOPS in Azure SQL Analytics?

 

If it is not a part of SQL Analytics, how must we configure alerts based on high memory usage?

 

Any feedback is appreciated.

1 Reply
Highlighted