I'm using Gen5 General Purpose Azure SQL Managed Instance with 4 vcores / 20.4GB memory. Today an application that uses this database had a very high workload and put the DB instance under heavy usage. I was monitoring the resource of this SQL MI instance and was able to see only %CPU but no memory usage was shown anywhere.
I googled and found nothing related to this. Is it possible to know how high the memory usage is at the moment?, and it would be great if we can see historical data like in the "Metrics" feature under "Monitoring" section.
One article I found from Google was this blog post but it only tells the allocated memory, not actual usage and I don't understand it very clearly. Does the "TotalAvailableMemoryGB" means the amount of memory that SQL Server will be able to use, and "NonSOSMemGapGB" means the reserved memory which cannot be used by SQL Server?