Thanks for the follow up and outstanding work of Tim Hunt.
Yesterday at 4pm we upgraded and saw the new scheduled task. On our server - judging by the cpu spike - it looks like the process takes about 2 minutes to complete and it was set to run every 15 minutes or possibly on the hour at 15 minutes. Well, since school was out we made it run every 2 minutes.
It went from 17,884,346 questions yesterday down to 13,775,188 questions this morning.
We switched back to every 5 minutes and are monitoring performance hits as school is in session. We haven't noticed anything yet.
On the bright side of all this... We know our servers can handle many, many, many more quiz questions from teachers!!!
The upgrade seems to be working and hopefully by next week we will be back to normal. I can't believe we didn't catch this question growth sooner but glad there was such a nice fix and cleanup solution.
Is there any reason I shouldn't set the time interval so low?
Thanks again,
Chris