Solved: (urgent!!!)How to conduct interface test, performance test and automatic test projects created by power apps using canvas application mode, and how to monitor the resource usage of application server and database service (cup, memory)

Hello, everyone.

Our project is a program created by using the power apps canvas application. I am responsible for the content of performance testing. I need to carry out interface test and performance test on the application program, and monitor the resources of the application server and database server. At present, the performance test and load test of the Microsoft platform have been disabled, so we can't use the Microsoft platform to do these tests,The Microsoft platform recommends a free testing tool commonly used in the market, Apache JMeter performance testing tool, which supports many different protocols, such as HTTP, FTP, TCP request, etc.

The first problem encountered is: what kind of protocol is the canvas application project developed based on, what protocol is the functional interface development based on, how to confirm the request parameters and return results, similar to the HTTP interface, the development can use the postman tool to verify whether the interface is correct, and whether there is a specific function example template reference

Problem 2: how to monitor the resource utilization of servers (including database servers and application servers) in real time, and whether they can be monitored for a long time. For example, the stability test of the system requires real-time monitoring for up to 24 hours

Categories:

General Questions

@Anonymous

To validate your Power Apps (Canvas), you use Power Apps inbuilt test suite:

https://docs.microsoft.com/en-us/power-platform-release-plan/2019wave2/microsoft-powerapps/test-framework

https://powerapps.microsoft.com/en-us/blog/introducing-test-studio-to-build-end-to-end-tests-and-maintain-your-app-quality/

By using this test framework, you can create many user interface tests.

@RezaDorrani created a Youtube video on how to use this test framework. https://www.youtube.com/watch?v=jDAu0ECtD5Q

Also, by using Monitoring option from Power Apps, you can check your formulas from the Canvas App how much time they are taking to query the data from your data sources.

If you are using SQL as your data source, you can also use SQL Profiler to check all queries from Power Apps.

I hope above information will be useful for you.

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.