Showing results for 
Search instead for 
Did you mean: 

ePO 5.3 SQL Server CPU 100%

Recently upgraded our AWS instance from 4 vCPUs to 8 vCPUs. Running ePO 5.3 and wondering why the past 3 days @ around 12-1am, the CPU spikes like crazy. It's the SQLServer service causing it, and digging into SQL 2014 Mgmt Studio, it's one query that's causing crazy cpu_time which is:


INSERT INTO PAFileIntegrityEventUserLink (EventID, UserID)
SELECT @eventID, userid from #PA_USERS
FROM PAFileIntegrityEventUserLink
WHERE EventID = @eventID and UserID = #PA_USERS.userid)


Just curious if anyone knows is there anyway to check what might be causing this? I'm new to ePO, what should I check for to see if it's scheduled each day, maybe updates or something? Not sure how to check how often ePO pulls them. I'm guessing because the table starts with PA, possible something with the Policy Auditor?

2 Replies
McAfee Employee cdinet
McAfee Employee
Report Inappropriate Content
Message 2 of 3

Re: ePO 5.3 SQL Server CPU 100%

What client or server tasks run around that time?  Any changes to policy auditor at all?  That is referencing a policy auditor event.  I will move this post over to them.

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?

Re: ePO 5.3 SQL Server CPU 100%


There are no tasks in task scheduled at that time, nothing that would strain the server. Also when I go to Client Task Catalog I don't see anything under policy auditor. And when looking through the system tree, none of the Assigned client tasks start anywhere near midnight, a few start at 5:00AM. Unless on epo it's using UTC time.
More McAfee Tools to Help You
  • Subscription Service Notification (SNS)
  • How-to: Endpoint Removal Tool
  • Support: Endpoint Security
  • eSupport: Policy Orchestrator
  • 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