SQL SERVER – HOW TO : TEMPDB won’t shrink even if there is unused space available

It could happen that the TEMPDB grows and even if you try to shrink it the size does not decrease.

The problem could be caused by cache data not being cleared.

In this cases you could use some commands that clear these cached data.

Read this article to understand what you can do in these cases

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s