Skip to content

Tempdb continually filling after sql server gets hung on a process

Featured Replies

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.

  • Author

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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.