Free Preparation Discussions
MENU
Microsoft Exam MB-700 Topic 3 Question 61 Discussion
Topic #: 3
A company uses Dynamics 365 Supply Chain Management.
The system has a slow response time when sales orders are entered.
You need to identify any blocking SQL statements.
Which Lifecycle Services (LCS) tool should you use?
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.
Viki
2 months agoAlyce
1 days agoShaniqua
4 days agoReed
12 days agoKaty
29 days agoErasmo
1 months agoHailey
1 months agoFannie
2 months agoKeith
28 days agoIsreal
1 months agoLucina
2 months agoViva
2 months agoLai
2 months agoGlennis
21 days agoMollie
25 days agoElouise
1 months agoJutta
2 months agoJosephine
2 months agoIsidra
2 months agoNickolas
2 months ago