How to check EPO - SQL database queries/connection speed
We are currently using EPO version 5.3.2 installed on an virtual MS Server 2012 R2 with 16 GB RAM and 4 core Xeon E5-2670 @ 2.50 GHz CPU. The EPO database is hosted on an additional virtual MS Server 2016 with MS SQL Server 2016. All is working well but we have one problem regarding dashboards and queries. It takes 1-2 minutes until the dashboard with important queries appear. It makes no difference regarding response times if there are 100 or 1000 clients available on EPO. I also cleaned up the client and tread events but without success. If I try to search one machine in System Tree than the query takes prox. 10 seconds. The little circle on top at the end of the columns row is blinking then. SSL encryption is not active in regard of the EPO – Database connection setting.
What can I do to find out the bottleneck in regard of this huge query response times?