ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 89 - MB-700 discussion

Report
Export

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.

A.

Blocking statements

Answers
A.

Blocking statements

B.

Batch requests

Answers
B.

Batch requests

C.

Database File 10

Answers
C.

Database File 10

D.

Executing statements

Answers
D.

Executing statements

E.

Executing indexes

Answers
E.

Executing indexes

Suggested answer: A, D

Explanation:

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.

Etc.

Reference: https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/lifecycleservices/performancetroubleshooting

asked 05/10/2024
Luyanda Hatta
34 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first