USE tempdb;
GO

-- Monitorear el crecimiento de archivos de tempdb
SELECT
    DB_NAME(database_id) AS [Database Name],
    type_desc AS [File Type],
    name AS [Logical Name],
    size_change_kb / 1024 AS [Size Change MB],
    duration_seconds
FROM
    sys.dm_io_virtual_file_stats(DB_ID('tempdb'), NULL) AS divfs
CROSS APPLY
    sys.dm_io_virtual_file_stats(DB_ID('tempdb'), file_id) AS divfs2
WHERE
    file_id IN (1, 2); -- Archivos de datos y de registro de tempdb respectivamente
GO