Thursday, July 21, 2011

TempDB size

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

No comments:

Post a Comment