DP-300 Certification Practice Question #296

Question

You need to identify the cause of the performance issues on SalesSQLDb1.
Which two dynamic management views should you use? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

Accepted Answer

To identify database performance issues (such as blocking or long-running queries) on SalesSQLDb1 (an Azure SQL Database), you must use native SQL Server/Azure SQL DMVs. `sys.dm_exec_requests` returns currently executing requests (including wait type, duration, and status), while `sys.dm_tran_locks` provides information about active locks and lock requests that are waiting to be granted. Options A, B, and E are Parallel Data Warehouse (PDW) / Azure Synapse Analytics views, which are not applicable to Azure SQL Database.

More DP-300 practice questions