How to check the amount of Azure SQL Managed Instance usage

Question

Hi There!

We would like to understand the amount of Azure SQL Managed Instance usage (CPU usage, data I/O, etc.). We would like to grasp the amount of usage by internal user or schema, but is there any way to achieve this?

Answer 1

Hi @Yuta Harada Thank you for posting your question on Microsoft Q&A and for using Azure services.

My understanding is that you are looking to see the amount of Azure SQL Managed Instance usage (CPU usage, data I/O, etc.) and the amount of usage by internal user or schema.
For the First question, I suggest using the regular SQL Server queries, such as:

SELECT [type] AS [ClerkType], SUM(pages_kb) / 1024 AS [SizeMb]
FROM sys.dm_os_memory_clerks WITH (NOLOCK)
GROUP BY [type]
ORDER BY SUM(pages_kb) DESC

Overview of available options here: Monitoring and performance tuning - Azure SQL Database | Microsoft Learn

CPU usage can be easily monitored with: Monitoring and performance tuning - Azure SQL Database | Microsoft Learn

For the second question: **The amount of usage by internal user or schema. **
There is no such statistics in SQL Server to my knowledge.

hope that helps

Regards,
Oury

Answer 2

Hi @Yuta Harada ,

Could be this helpful for you?

https://learn.microsoft.com/en-us/answers/questions/558870/how-to-see-current-available-sql-managed-instance.html