8
In some situations, two database sessions get stuck waiting for eachother. Based on the exact statments and the knowledge of processes being executed, we sometimes decide to KILL one statement in order to allow the most important session to complete it's task.
With the option of "SQL Now" in LCS, we are able to see the blocking sessions, and are able to see the exact SQL statements. We do however no longer have an option to kill one session to allow a second session to be completed.
STATUS DETAILS
Completed
Comments
Great suggestion!
Category: Lifecycle Services
Lane Swenka (administrator) on 6/24/2019 10:30:19 PM
Thank you for your feedback.
We released this feature as part of the functionality in self-service actions.
Please refer to the following link for more information:
https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/lifecycle-services/performancetroubleshooting#details
Sincerely,
Lane,
Microsoft.