ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 77 - MB-700 discussion

Report
Export

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?

A.

SQL Insights - Live View

Answers
A.

SQL Insights - Live View

B.

SQL Insights - Index Analysis

Answers
B.

SQL Insights - Index Analysis

C.

Telemetry data monitoring

Answers
C.

Telemetry data monitoring

D.

Performance SDK

Answers
D.

Performance SDK

Suggested answer: A

Explanation:

All SQL performance tools in LCS are available under the SQL Insights tab on the Environment Monitoring page for a specific environment. The following tabs are available:

Live View – Shows executing statements and blocking statements. The current SQL Now page that shows performance issues will be replaced with Live View.

Index Analysis – Shows aggregated index and table information, based on user scans, user seeks, user updates, and row count. Like performance metrics, this tool shows the trend for the selected index along with additional table metrics.

This feature is not available in self-service environments.

Queries – Shows a list of predefined queries that can be used to retrieve metrics on demand.

Examples of queries include a current blocking tree, a list of active plan guides, and a list of most expensive queries.

Etc.

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

asked 05/10/2024
Santosh Kumar
41 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first