A company uses Dynamics 365 Finance. The company experiences performance issues with several forms in production. You need to use Live View SQL performance metrics to identity potential issues that oc

Question

Options

• ABlocking statements
• BBatch requests
• CDatabase File IO
• DExecuting statements
• EExecuting indexes

• A
  77% (23)
• B
  7% (2)
• C
  13% (4)
• E
  3% (1)

Explanation

In Dynamics 365 Finance, the Live View SQL performance tool provides real-time SQL diagnostics. The two relevant metrics for identifying performance issues are Blocking statements (A) and Executing statements (D). Blocking statements reveals queries that are being blocked by other transactions, which is a primary cause of form slowness and timeouts. Executing statements shows queries actively running at that moment, enabling identification of long-running or expensive SQL operations. The other options are incorrect: Batch requests (B) is a high-level throughput counter, not a real-time SQL diagnostic; Database File IO (C) relates to disk I/O at the storage level and is not surfaced in the Live View SQL tool; and Executing indexes (E) is not a metric exposed by this tool.

No community discussion yet for this question.