tempdb size with sql server

USE master;

go

SELECT name AS 'File',

CAST(CAST(SIZE*1.0/128 AS DECIMAL(9,2)) AS VARCHAR(12)) + ' Mb' AS 'File Size',

CASE max_size WHEN 0 THEN 'Off'

WHEN -1 THEN 'On'

ELSE 'Will grow to 2 Tb'

END AS 'Auto Growth',

growth AS 'Growth',

CASE WHEN growth = 0 THEN 'size is fixed and will not grow'

WHEN growth > 0 and is_percent_growth = 0 THEN 'Growth in 8Kb pages'

ELSE '%'

END AS 'Increment'

FROM tempdb.sys.database_files;





USE tempdb

GO

EXEC SP_SPACEUSED;