How to check the amount of Azure SQL Managed Instance usage

Yuta Harada 101 Reputation points
2022-07-15T03:17:52.22+00:00

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?

Azure SQL Database
0 comments No comments
{count} votes

Accepted answer
  1. Oury Ba-MSFT 15,116 Reputation points Microsoft Employee
    2022-07-20T19:26:31.08+00:00

    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


1 additional answer

Sort by: Most helpful
  1. T. Kujala 8,686 Reputation points
    2022-07-15T04:04:43.037+00:00