Exam DP-300 topic 3 question 48 discussion

Actual exam question from Microsoft's DP-300

Question #: 48
Topic #: 3

HOTSPOT
-

You have an Azure SQL managed instance named SQLMI1 that hosts multiple databases.

You need to monitor the performance of SQLMI1 and identify which database uses the most memory and the most disk I/O.

Which objects should you query? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer:

by U_C at April 7, 2023, 4:12 a.m.

Comments

Submit Cancel

U_C

Highly Voted 2 years ago

For memory is sys.dm_os_buffer_descriptors. You can use this query to prove: SELECT DB_NAME(database_id) AS database_name, COUNT(*) * 8/1024.0 AS cached_MB FROM sys.dm_os_buffer_descriptors GROUP BY database_id ORDER BY cached_MB DESC; For I/O, the answer is correct. SELECT DB_NAME(database_id) AS database_name, SUM(num_of_reads + num_of_writes) AS total_io_operations FROM sys.dm_io_virtual_file_stats(NULL, NULL) AS virt_file_stats GROUP BY database_id ORDER BY total_io_operations DESC;

upvoted 15 times

...

nova24

Most Recent 5 months, 2 weeks ago

For memory: sys.dm_os_buffer_descriptors For disk I/O: sys.dm_io_virtual_file_stats

upvoted 3 times

...

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam

Exam DP-300 topic 3 question 48 discussion

Comments

U_C

nova24

SY0-701