HOW TO CHECK USAGE OF tempdb OF SQL SERVER

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