We are experiencing an issue where several collections has a Current Status of Awaiting Refresh. They have continued to stay in this status for 2 days. We've verified that no blocking exists in SQL, checked for a bad query and have performed a Site Reset. We have also noticed that when we restart SMS_COLLECTION_EVALUATOR it forces a full collection evaluation of every collection in our environment (~7900). We see 7900 items hit the coleval.box and we also see them queued for processing in the Colleval.log. Also, if we manually update the Collection Membership of a single collection (Awaiting Refresh or Ready) this also forces an evaluation of every collection in our environment. Any Ideas??? TIA

Are you using R2? If so, there is a collection evaluator tool in the R2 toolkit that will help you troubleshoot the queries and collections that are having issues.

Also think about how your collections are setup in terms of limiting. There could be a cascading effect.

http://www.sysadmintechnotes.com/2013/09/11/the-effect-of-a-limiting-collection-full-update/