cancel
Showing results for 
Search instead for 
Did you mean: 

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?

Thanks a lot.

Best regards from Germany

Janni

You Deserve an Award
Don't forget, when your helpful posts earn a kudos or get accepted as a solution you can unlock perks and badges. Those aren't the only badges, either. How many can you collect? Click here to learn more.

Community Help Hub

    New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.

  • Find Forum FAQs
  • Learn How to Earn Badges
  • Ask for Help
Go to Community Help

Join the Community

    Thousands of customers use the McAfee Community for peer-to-peer and expert product support. Enjoy these benefits with a free membership:

  • Get helpful solutions from McAfee experts.
  • Stay connected to product conversations that matter to you.
  • Participate in product groups led by McAfee employees.
Join the Community
Join the Community