He there.

Yeah- that is a possibility. It could be that the params being called weren't the usual ones.

What happened was a bot crawled our site and was hitting a lot of pages that aren't usually hit, with strange options etc, so probably passing a bunch of not frequently called params.

Am I right in guessing that because they were unusual params, that the query optimiser didnt use indexes efficiently, causing an increase in the CPU used for that proc.

If so, how would we mitigate against this happening in the future?