:How do I view the RDS SQL Server of An memory usage instance?

Overview

This article describes how to view the RDS SQL Server of An memory usage instance.

 

Background information

Alibaba Cloud reminds you that:

• When you perform operations that have risks, such as modifying instance configurations or data, check the disaster recovery and fault tolerance capabilities of the instances to ensure data security.
• Before you modify the configurations and data of instances including but not limited to ECS and RDS instances, we recommend that you create snapshots or enable RDS log backup.
• If you have authorized or submitted security information such as the logon account and password in the Alibaba Cloud Management console, we recommend that you modify such information in a timely manner.

1. Use a client to connect to an instance. For more information, see connect to an instance.
2. Run the following SQL statement to view the memory usage of each database:

   select count(*)*8/1024 as 'cache size(MB)',
          case database_id
              when 32767 then 'ResourceDb'
              else DB_NAME(database_id)
          end as 'datebase'
   from sys.dm_os_buffer_descriptors
   group by DB_NAME(database_id)
            database_id
   order by 'cache size(MB)' desc

3. To view the sys.dm_os_memory_clerks of a memory usage table, run the following SQL statement:

   select * from sys.dm_os_memory_clerks

 

Application scope

• ApsaraDB RDS for SQL Server