how to find the cpu memory disk and network of the OS where RDS is residing

Question

hi,

i have one RDS, but i do not have any other permissions, and i need to know the cpu , memeory disk and network staus of

the OS where RDS is residing.

if i had sqlserver on my machine it was so easy for me to press alt ctrl del to find the status of these four things. but in rds i am not able to get. the activit monitor is not showing few graphs also.

so pls tell me if there is any query by using i can find the detials.

or any tool.

 

yours sincerely

Answer 1

Hi，Rajesh Kumar Yadav

Welcome to Microsoft Q&A fourm！

I recommend you two tools: one is Amazon CloudWatch, and the other is the Performance Dashboard in SSMS.

Amazon CloudWatch refer to

https://docs.aws.amazon.com/AmazonCloudWatch/latest/monitoring/WhatIsCloudWatch.html

Performance Dashboard refer to

https://learn.microsoft.com/en-us/sql/relational-databases/performance/performance-dashboard?view=sql-server-ver16

so pls tell me if there is any query by using i can find the detials.

This is a quick query to check memory usage.

SELECT
    physical_memory_in_use_kb / 1024 AS [SQL Server Memory Usage (MB)],
    (physical_memory_in_use_kb + virtual_address_space_reserved_kb) / 1024 AS [Total Server Memory (MB)],
    available_commit_limit_kb / 1024 AS [Available Physical Memory (MB)]
FROM
    sys.dm_os_process_memory;

Best Regards,

Mikey Qiao

---

If you're satisfied with the answer, don't forget to "Accept it," as this will help others who have similar questions to yours.