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
WHERE NOT EXISTS
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?
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?