1.5 Work with performance and monitoring tools in finance and operations apps

Question 1

Trace parser?

Answer 1

Consume traces and analyze performance in F&O

Question 2

What does using trace parser ensure?

Answer 2

To get an idea what is currently happening in deployed environments and helps ensure that business users have the response time that they need for their daily processes

Question 3

How to use trace parser?

Answer 3

Available in “PerfSDK” folder on dev environment
Install the tool
To capture a trace, ensure that list of tasks needed to analyze is completed
Add system tracing user role to user for tracing
In frontend top-right of the screen select question mark icon, click “Trace” -> “Start Trace”
Perform all actions before hitting “Stop trace”

Question 4

When is performance load test is performed?

Answer 4

To test the environment under normal, real-life load conditions
Help the system to adjust and see how it runs under normal conditions of a single or multiple users

Question 5

Steps to perform a performance test with performance SDK?

Answer 5

1. Create a task recording of a business process. Save, download XML file, configure dev environment
2. Generate C# performance tests from the file. Add references to specific DLLs and create new C# classes
3. Once setup is complete, run a single user testing in Test Explorer through VS. Run business process’s end -to-end scenario before you capture
4. When recording scenario, enter values manually instead of selecting them
5. Replay task recording before downloading to make sure every step has been recorder

Question 6

Multi-user performance test environment prerequisites?

Answer 6

VS Enterprise Edition needs to be in dev environment
Need to have tier-2 or above environment on the same application and platform update as your dev environment
Must perform a atleast a single user test

Question 7

Where are SQL performance tools are viewed?

Answer 7

In LCS - > Environment Monitoring page on SQL insights

Question 8

Performance metrics?

Answer 8

Shows most expensive queries that were run during a selected period based on duration in ms, logical input/output, execution count, CPU time in ms, and waittime.

Question 9

How often is data collection pulled, and how long is it stored for performance metrics?

Answer 9

Data collection is pulled once daily and stored for 30 days

Question 10

Index analysis?

Answer 10

Shows aggregated table and index information from user scans, seeks, updates, and row count

Question 11

Live view?

Answer 11

Shows you the current DTU and running and blocking statements

Question 12

Queries?

Answer 12

Shows a list of predefined queries that are used to retrieve metrics on an on-demand basis.
Runs synchronously to ensure that the results are returned instantaneously

Question 13

Actions?

Answer 13

Shows a list of predefined actions that you should use to mitigate issues in sandbox and production environments

Question 14

Why use SQL Profiler?

Answer 14

See all the long-running queries on the SQL server system, not just the long-running queries in F&O apps

Question 15

How to access and use SQL profiler?

Answer 15

Open SSMS
Go to Tools -> SQL Server Profiler
Name a trace, specify properties
While running perform the processes that are of concern
When done, hit stop button
Analyze traces

Question 16

How to view measurements and diagnostics of the environment?

Answer 16

Using Environment Monitoring and SQL Insights

Question 17

What types of health checks can be performed within the health metrics interface?

Answer 17

AOS
Batch frameworks
Data import/Export framework
MS Azure SQL
Management reporter