BeyondERP.Newsletter
Menu

Job page · System administration

Run performance test

A page (Performance test) that times a set of database and cache tests for the number of records you enter: data manipulation, queries, TempDB and in-memory tables, and the system global object cache.

Business process
Administer system features
Menu item
PerformanceCheck
Setup steps
1 on this page
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA page (Performance test) that times a set of database and cache tests for the number of records you enter: data manipulation, queries, TempDB and in-memory tables, and the system global object cache.
What you do hereUse it to measure how this environment performs the basic database operations, for example to compare a sandbox before and after a change.
ExampleFor example, the BEAT administrator runs the test with 1,000 records, which the page says takes about a minute, in the sandbox before and after an update and compares the Result section.
Run performance test page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processAdminister system features
Menu pathSystem administration › Periodic tasks › Run performance test
Set up firstConfigure performance tool Microsoft Learn
Used next byMonitoring and telemetry parameters Microsoft Learn
Related pagesOptimization advisor Microsoft Learn
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

When to run it

When to run itWhen you want to compare how an environment performs basic database operations, for example before and after an update.
How oftenOn demand.
What the output showsTimings per test in the Result section.

Source: Checked in Dynamics 365

Setup steps on this page

Compare database performance with the performance test

Time basic database operations in an environment.

How to use it

  1. Go to System administration > Periodic tasks > Run performance test.
  2. In Record count to test, enter the number of records; 1,000 records take about a minute, and the maximum is 100,000.
  3. Turn on the tests you need under Data manipulation, Query, TempDB and InMemory, and Cache, or use Select all test options.
  4. Select Run.
  5. Read the timings in the Result section.

Source: Checked in Dynamics 365

Fields on the page

FieldWhat it meansExample
Record count to testNumber of records each test uses. The page warns that 1,000 records take about a minute and that larger numbers can hit form timeouts; the maximum is 100,000.Checked in Dynamics 3651000
Select all test optionsTurns all tests on or off at once.Checked in Dynamics 365Yes
Table cache useWhether the tests use the table cache.Checked in Dynamics 365Yes
Data manipulationInsert, Update, Record insert list, Insert record set, Update record set and Delete from.Checked in Dynamics 365
QueryLarge buffer read, Cluster index, Unique index with and without cache hit, and Non-unique index.Checked in Dynamics 365
TempDB and InMemoryTests on TempDB and in-memory temporary tables.Checked in Dynamics 365
System global object cacheTest of the global object cache.Checked in Dynamics 365
ResultThe timings of the run.Checked in Dynamics 365
Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Compare database performance with the performance test1,000 records in a sandbox, same options before and after a changeThe page states 1,000 records take about a minute and larger numbers risk form timeouts.Where is the performance test run?Running 100,000 records in production during business hours.Test: The test produces timings

Feature management and licence

Licence or add-inNo Feature management feature needs to be turned on for this page.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyRuns in the environment you are signed in to; the test creates and deletes its own records. Checked in Dynamics 365
Can it be undoneReversible: The test works on its own test records and changes no business data. Checked in Dynamics 365
If you change it laterLarge record counts load the database and can run into form timeouts, so keep counts small and avoid busy hours. Checked in Dynamics 365
Technical architect

6Technical

Menu itemPerformanceCheck Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=PerformanceCheck
Data migrationLoad order: Run performance test has no data entity in Data management, so it can't be loaded from a file or a configuration template. It is a diagnostic page with no data to move.Checked in Dynamics 365
Everyone

8Sources