SELECT SUM(size)/128 AS [Total database size (MB)] FROM tempdb.sys.database_files
SELECT * FROM sys.dm_os_performance_counters WHERE
instance_name = 'tempdb' order by cntr_value desc
SELECT * FROM sys.dm_os_performance_counters WHERE counter_name IN ('Data File(s) Size (KB)', 'Log File(s) Size (KB)', 'Log File(s) Used Size (KB)') AND
instance_name = 'tempdb'
SELECT instance_name AS 'Database', *
FROM
(SELECT * FROM sys.dm_os_performance_counters WHERE counter_name IN ('Data File(s) Size (KB)', 'Log File(s) Size (KB)', 'Log File(s) Used Size (KB)') AND instance_name = 'tempdb') AS A
PIVOT (MAX(cntr_value) FOR counter_name IN ([Data File(s) Size (KB)], [LOG File(s) Size (KB)], [Log File(s) Used Size (KB)])) AS B
Frage:
How to check Tempdb usage sql server