Recommendations:

• Put TempDB on fast storage (SSD/NVMe)

• Use multiple TempDB files (equal to the number of logical cores up to a maximum of 8)

Current size of TEMPDB

ALTER DATABASE [tempdb] MODIFY FILE (NAME = [tempdev], FILENAME = 'T:\SQLTemp\tempdb.mdf');

ALTER DATABASE [tempdb] MODIFY FILE (NAME = [templog], FILENAME = 'T:\SQLTemp\templog.ldf');

You need to restart SQL Server for this to take effect.

Try this, it should shrink TEMPDB leaving 10% free space .

dbcc shrinkdatabase (tempdb, 10)

If this doesn't work (which is common) restart the database instance if possible.

If you cannot restart the database instance (e.g. it's a production instance) then try these steps...

CHECKPOINT;

GO

DBCC DROPCLEANBUFFERS;

GO

DBCC FREEPROCCACHE;

GO

DBCC FREESYSTEMCACHE ('ALL');

GO

DBCC FREESESSIONCACHE;

GO

DBCC SHRINKFILE (TEMPDEV, 20480);

GO

DBCC SHRINKDATABASE (TEMPDB, 10);

GO