USE tempdb;
GO

-- Obtener el tamaño actual de tempdb y espacio utilizado
SELECT
    DB_NAME(database_id) AS [Database Name],
    type_desc AS [File Type],
    name AS [Logical Name],
    size * 8 / 1024 AS [Size MB],
    used_space_pages * 8 / 1024 AS [Used Space MB],
    (size - used_space_pages) * 8 / 1024 AS [Free Space MB]
FROM
    sys.dm_db_file_space_usage;
GO