TrapVarBinds

DELETE TrapVarBinds FROM (SELECT TOP 1000 TrapVarBinds.TrapID FROM TrapVarBinds LEFT JOIN Traps ON TrapVarBinds.TrapID=Traps.TrapID WHERE Traps.TrapID IS NULL) AS T1 WHERE(TrapVarBinds.TrapID = T1.TrapID)

Can someone tell me what this does? Seems to be eating tons of my SQL resources.

Thanks.

Find more posts tagged with

npm

trap_grooming

Accepted answers

All comments

bshopp

This is the trap grooming, which currently runs every minute.

How many traps/minute are you receiving?

jeff.stewart

I didn't think any. If I turn the Trap service off should I see this go away?

bshopp

Yep, if you turn it off, you shouldn't see that query anymore

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Help
Best Of