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)

The correct answer is A. SQL Insights - Live View. In Lifecycle Services (LCS), SQL Insights - Live View provides real-time visibility into currently executing SQL queries on the environment's database, including queries that are blocking other queries. This makes it the correct tool when you need to identify blocking SQL stateme

Manage implementations

Question

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?

Options

ASQL Insights - Live View
BSQL Insights - Index Analysis
CTelemetry data monitoring
DPerformance SDK

How the community answered

(22 responses)

A
86% (19)
C
9% (2)
D
5% (1)

Explanation

In Lifecycle Services (LCS), SQL Insights - Live View provides real-time visibility into currently executing SQL queries on the environment's database, including queries that are blocking other queries. This makes it the correct tool when you need to identify blocking SQL statements causing live performance degradation, such as slow sales order entry. SQL Insights - Index Analysis (B) is used to review missing or unused indexes, not active blocking. Telemetry data monitoring (C) provides aggregated event-level telemetry, not SQL-level blocking details. Performance SDK (D) is used for load and performance testing, not for diagnosing live blocking issues.

Topics

#LCS#Performance Monitoring#SQL Troubleshooting#Dynamics 365 SCM

Community Discussion

No community discussion yet for this question.

Full MB-700 Practice