You can use M-Files Admin to measure the performance of a specific vault to detect problems or bottlenecks in the performance of the vault. The performance tests measure the network round-trip time to the database server of the vault as well as the time it takes to insert 100,000 rows into the vault database.
Do the following steps to measure vault performance:
-
Click Performance.
Result:The Performance view is opened in the right-side pane.
The results of the tests are displayed in the
Duration column. If there are no remarks displayed in the
Remarks column, your vault should be performing optimally.
If
one or more of the tests took longer than their expected duration, a remark is
displayed in the Remarks column. If the network round-trip time
to the database server took longer than expected, it may be indicative of a slow
network connection or heavy traffic on the network. If the database insert speed
test took longer than expected, your server hardware may be insufficient or there
may be heavy load on the server.
Note: The vault performance tests have predefined
threshold times. The default threshold time for the network round-trip test is
1,500 microseconds, and for the database insert speed test, it is 6,000
milliseconds. For instructions on modifying the default threshold values, see
Settings for vault performance measurement.
Examining page file usage in Performance Monitor
You can use Windows Performance Monitor to check the paging file use. Low physical memory can slow the vault. To examine page file usage in Performance Monitor:
