Shrinking TempDB without Restarting SQL Server

Over the weekend I had a user who ran a large query in a test environment that used a bunch of space in tempdb.  On Monday morning I’m reviewing my servers in my monitoring tools and see the test server with low free space on the tempdb drive.  Even though this is a test server it is a bit disruptive to restart it during the middle of the work day.  But I also hate seeing warnings on any of my servers so I want to fix it now.

I found this great article on SQLSunday.com with steps you can take to shrink tempdb while SQL Server remains running.  I hope you find it useful too.

Leave a Reply

Your email address will not be published. Required fields are marked *