Jump to content




xerxes2985

Tempdb continually filling after sql server gets hung on a process



Recommended Posts

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.

Share this post


Link to post
Share on other sites


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

Share this post


Link to post
Share on other sites

@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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


×