Query to check Temp Db size immediately.
\
SELECT
[name] AS [Logical FILE Name],
CASE type_desc
WHEN 'ROWS' THEN 'Data'
WHEN 'LOG' THEN 'Log'
END AS [FILE Type],
physical_name AS [FILE PATH],
[SIZE] AS [FILE SIZE],
CASE growth
WHEN 0 THEN 'Enabled'
ELSE 'Disabled'
END AS [Auto Growth]
FROM tempdb.sys.database_files
\
SELECT
[name] AS [Logical FILE Name],
CASE type_desc
WHEN 'ROWS' THEN 'Data'
WHEN 'LOG' THEN 'Log'
END AS [FILE Type],
physical_name AS [FILE PATH],
[SIZE] AS [FILE SIZE],
CASE growth
WHEN 0 THEN 'Enabled'
ELSE 'Disabled'
END AS [Auto Growth]
FROM tempdb.sys.database_files
No comments:
Post a Comment