How do I stop my tempdb from filling up?

Question

We had split the TempDB data into 4 and then 6 files with no expansion and kept the log portion quite small with the ability to grow.Tempdb filling fast - MSDNTEMP DB keeps filling up - MSDN - Microsofttempdb Log Filling - Cannot find how or what - MSDNTempdb Problem - MSDNДругие результаты с сайта social.msdn.microsoft.com

What causes tempdb to fill up?

Most of the time tempdb fills is related to when a user kicks off a long running query and decides to get a cup of coffee, or go out to lunch.

How do I stop tempdb full?

Tips to prevent tempdb to go out of space:1Set tempdb to auto grow.2Ensure the disk has enough free space.3Set it's initial size reasonably.4If possible put tempdb on its separate disk.5Batch larger and heavy queries.6Try to write efficient code for all stored procedures, cursors etc.How to prevent tempdb database grows so large - Career Ride

What should I do if SQL Server tempdb is full?

CREATE the necessary space by dropping objects in the filegroup, adding additional files to the filegroup,or setting autogrowth on for existing files in the filegroup. When investigating a TempDB issue like this, most simply restart the SQL Server instance.

How do I restrict Tempdb growth?

You can set it by clicking on the elipses next to Autogrowth / Maxsize. You will set it in MB. A few other considerations for this. The tempdb can be used heavily based on your application design.

Expert · Answer