DP-300 Certification Practice Question #149

Question

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.

Accepted Answer

To identify which database uses the most memory: `sys.dm_os_buffer_descriptors` holds every page in the buffer pool with its database_id, allowing grouping to calculate MB cached per database. To identify which database uses the most disk I/O: `sys.dm_io_virtual_file_stats` provides read/write counts per database file (grouped by database_id gives total I/O per database). Both DMVs support the required per-database analysis. All signals are unanimous.

More DP-300 practice questions