Tempdb continually filling after sql server gets hung on a process

[xerxes2985]

In SCCM, any time I attempt to update a collection, it causes tempdb to fill up, and eventually causes SQL server to stop working properly. SQL Server databases reside on their own drive, and each time it gets hung on SMS_COLLECTION_AUXILIARY_EVALUATOR. I've specified a 50 GB limit for tempdb and a 30 GB limit for the log db.

Any suggestions.

[GarthMJ]

It means that your collection query is causing the problem. Review the query to fix the problem. 

[xerxes2985]

It happens even when using "direct" and not a query.

[xerxes2985]

I think I may have found the offender. Testing now.

[xerxes2985]

@GarthMJ you’re a lifesaver. Looks like my offending collection was trying to look at installed applications, display name, then I had it AND to AI class for Product Version. whatever reason I did that, removing that bad logic fixed it.

I owe you lunch sometime, somehow.

[GarthMJ]

? I will be at  https://mmsmoa.com/ this year.. feel free to look me up.