☰
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
ksw
Level 8
Report Inappropriate Content
Message 1 of 3
‎04-28-2021 11:28 AM

EPO queries in the database

Jump to solution

Hi,

Is it normal for ePO to make multiple queries to the database?

image (1).png

0 Kudos
Reply
1 Solution

Accepted Solutions
cdinet
Employee
Employee
Report Inappropriate Content
Message 2 of 3
‎04-28-2021 02:22 PM

Re: EPO queries in the database

Jump to solution

Yes, epo can have several hundred connections open at a time.  When I would be concerned is if the connection threads are excessive as in 10's of thousands or more.  If you are experiencing slowness when this occurs, you might want to open ticket with us to ensure there is no connection leak.

Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?

View solution in original post

0 Kudos
Reply
2 Replies
cdinet
Employee
Employee
Report Inappropriate Content
Message 2 of 3
‎04-28-2021 02:22 PM

Re: EPO queries in the database

Jump to solution

Yes, epo can have several hundred connections open at a time.  When I would be concerned is if the connection threads are excessive as in 10's of thousands or more.  If you are experiencing slowness when this occurs, you might want to open ticket with us to ensure there is no connection leak.

Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?

0 Kudos
Reply
JoeBidgood
Employee
Employee
Report Inappropriate Content
Message 3 of 3
‎04-28-2021 06:55 PM

Re: EPO queries in the database

Jump to solution

To add to this - do you use the Network Security Manager?  If so please see KB92859 - one of the possible symptoms of this issue is many sleeping "select top 1 * from eposerverinfo" queries as shown in your sp_whoisactive screenshot. This can be resolved by upgrading the NSM extension.

HTH -

Joe

0 Kudos
Reply
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 our Community for peer-to-peer and expert product support. Enjoy these benefits with a free membership:

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

TrellixSkyhigh Security | Support Trellix.com SkyhighSecurity.com

Legal Privacy Copyright © 2023 Musarubra US LLC