>> To have a successful onboarding experience
to the Cloud service for Microsoft Dynamics
365 for Finance and Operations,
you must always know the health of your environments.
You must also be able to
troubleshoot any health issues that occur.
Microsoft Dynamics Lifecycle Services,
also known as LCS,
is the administration center for Finance and Operations.
It contains a collection of
monitoring and diagnostic tools that
can help you gain an accurate view
of the environments that you manage.
In this video, we'll show how to monitor
key performance counters by
using LCS Environment monitoring.
Open LCS and then open the appropriate project.
In the "Environment" section,
select the "Environment" to
view and then click "Full Details."
On the "Environment Details" page,
click "Environment Monitoring" to open
the monitoring and diagnostics portal.
On the "Environment monitoring" page,
on the "Activity" tab,
find the "Sequel Utilization Chart".
Sequel utilization is shown
in Database Transaction Units,
also known as DTUs.
For a single Microsoft Azure SQL Database
had a specific performance level and a service here,
Microsoft guarantees a specific level of
resources and a predictable level of performance.
These levels are independent of
any other database in the Azure Cloud.
The amount of resources is calculated as a number of
DTUs and is a blended measure of CPU,
memory, and input/output, also known as I/O.
For more information about DTUs,
see the Database Transaction Units (DTUs) and elastic
Database Transaction Units
(eDTUs) article on docs.Microsoft.com.
In the "UTC time" field,
specify the time to verify
sequel utilization for them and then set the "Period",
"Minutes" field to negative 60.
Click "Submit Time."
The chart will show you the DTU of
the database for a period of one hour to
verify whether there is any period that is
a high DTU load of up to 100 percent.
You can zoom in on any period in the chart.
Hover over the period that you're interested in.
Click, and hold the left mouse button,
and drag to select the period.
The chart will zoom in on that period.
To reset the zoom, click "Reset Zoom."
Scroll down to the "User
Load" and "Activity Load" sections
of the activity tab to further analyze the activity.
Scroll back up and click "View raw logs".
On the raw logs page and the "Query Name" field,
select "Slow Queries." Click "Search."
Review the list of slow queries and
identify any queries that must be tuned.
A query is considered slow if it's
execution time is longer than 100 milliseconds.
You can click "Export grid" to export
the results to a Comma Separated Values file,
also known as a CSV file.
Next, we'll look at key performance
counters for the various virtual machines.
On the Environment monitoring page in LCS,
click the "Health Metrics" tab. Click "System."
Key performance counters are shown
for the various virtual machines.
Click the "Magnifying Glass" that contains
a "Plus" sign to zoom in on the graph.
Click "1w" to see the history of the past week.
The Memory Available (MBytes) counter shows the amount of
physical memory in bytes that's
available to processes that run on the server.
The amount is calculated by
adding the amount of space on the zero,
free, and standby memory lists.
Verify that enough memory is still
available for the various virtual machines.
The CPU Utilization percent counter
monitors the amount of time
that the Central Processing Unit,
also known as CPU,
spends running a thread that isn't idle.
A consistent state of
80 to 90 percent might
indicate that the server is over utilized.
Verify this counter for the various virtual machines.
Next, we'll look at SQL Performance Metrics.
On the Environment monitoring page in LCS,
click the "SQL Insights" tab
then click the "Performance Metrics" tab.
In the "Start time UTC" and "End time UTC" fields,
enter the "Start" and "End" times for
a period and coordinated universal time,
also known as UTC.
Click "Apply". In the "Metric" section,
you can see multiple charts of
SQL query executions for the specified period.
These charts are ordered by duration,
logical input/output, CPU time,
execution count, and total wait time.
In any of the charts,
you can zoom in on an area.
Hover over the area that you're interested in.
Click, and hold the left mouse button,
and drag to select the area.
This chart will zoom in on that area.
To reset the zoom, click "Reset zoom."
Click any of the bars in the chart.
Notice that the selected bar
is now highlighted in yellow.
Scroll down to the "Query Detail" section
and click the "Trend" tab.
In the charts, you can see how the query resolution for
the selected query changed over
time in terms of duration,
logical inputs/output, CPU time,
execution count, and total wait time.
Click the "SQL Statement" tab to view the query text for
the selected query together
with key performance characteristics.
Click "Download query plan" to download the query plan.
You should now have enough information to further
analyze the query and implement any required tuning.
On the Environment Monitoring page and LCS,
click the "SQL Insights" tab
and then click the "SQL Now" tab.
You'll see the current activity on
the SQL Azure Database.
There are three sections: Currently executing statements,
Blocking statements, and Lock info.
All this information can help you gain
real-time performance insight into
the Finance and Operation system.
This brings us to the end of this presentation.
We hope you found this information
useful. Thank you for watching.