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 occur in real time.
You need to recommend a solution to troubleshoot performance issues.
Which two performance metrics should the company use? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
AD: Live View -- Shows executing statements and blocking statements.
A: Sample flow
Scenario: Users report slow performance when using the system. One issue could be a blocking statement. Blocking by itself is typical in a healthy system and is only a problem when it becomes excessive or starts degrading business activities.
Go to the Live View tab and check if there are any blocking statements. If there is a blocking statement, copy the blocking query ID.
Open the Queries tab and select the Current Blocking Tree query. This will return the root blocker that is blocking the SQL operation.
Currently there are no comments in this discussion, be the first to comment!