Deal of the Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam MB-700 Topic 3 Question 61 Discussion

Actual exam question for Microsoft's MB-700 exam
Question #: 61
Topic #: 3
[All MB-700 Questions]

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.

Show Suggested Answer Hide Answer
Suggested Answer: A, D

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!

Save Cancel