We are trying in production for the first time and in many server, we deployed it in 40 servers and we saw that OsQuery use up to 1.4gb of memory. I couldn´t find any information or workarround or even if it is normal consumption, look at this graph..
I found out what was going on with this specific query. Apparently, if the query brings in too much data, there’s some kind of leak. So, I have to tweak the logic to limit the data returned by the query
Would you be able to share the specific query you were having issues with so that if someone runs into this problem in the future they can more easily find the solution?