We have a problem with the production environment and need some fast help.
For some reason, posting documents on our Business Central production environment (on-premise) works very slowly. For example, we need about 30+ second to post purchase order with only 3 lines, the same is on sales documents. Posting general journal or payment reconciliation journal running more than 2 hours for 2000 rows.
Creating and viewing documents have no that kind of performance problem.
We turned off all extensions, server performance is good (servers always running on less or equal 30% od capacity). We enabled telemetry on Azure (at least as far as we know how to enable it and read problems). On each slow thread reports show that it works on the Base Application level.
If you have experience with this kind of unexpected work and troubleshooting or know someone who can help us, please contact me.
We are not very experienced in Telemetry and SQL and cannot imagine what can be problem, so any help or advice will be helpful. Thank you in advance!