TSQL Script - to Find Details About TempDB

SELECT name AS FileName,

size*1.0/128 AS FileSizeinMB,

CASE max_size WHEN 0 THEN 'Autogrowth is off.'
              WHEN -1 THEN 'Autogrowth is on.'
              ELSE 'Log file will grow to a maximum size of 2 TB.'
              END AutogrowthStatus,

growth AS 'GrowthValue',

'GrowthIncrement' = CASE WHEN growth = 0 THEN 'Size is fixed and will not grow.'

WHEN growth > 0AND is_percent_growth = 0 THEN 'Growth value is in 8-KB pages.'

ELSE 'Growth value is a percentage.'END
FROM tempdb.sys.database_files;


Reference : Pinal Dave (http://blog.SQLAuthority.com)

No comments: