Tuesday, July 2, 2024

Espacio utilizado por la tablas en SQL Server - table space already used into SQL server or TSQL

Query para conocer el detalle de espacio utilizado por las tablas

 SELECT 

t.NAME AS Tabla,

s.Name AS Esquema,

p.rows AS NumeroDeFilas,

CAST(ROUND(((SUM(a.total_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS TotalEspacio_MB,

CAST(ROUND(((SUM(a.used_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS EspacioUtilizado_MB, 

CAST(ROUND(((SUM(a.total_pages) - SUM(a.used_pages)) * 8) / 1024.00, 2) AS NUMERIC(36, 2)) AS EspacioNoUtilizado_MB

FROM

sys.tables t

INNER JOIN sys.indexes i ON t.OBJECT_ID = i.object_id

INNER JOIN sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id

INNER JOIN sys.allocation_units a ON p.partition_id = a.container_id

LEFT OUTER JOIN sys.schemas s ON t.schema_id = s.schema_id

GROUP BY t.Name, s.Name, p.Rows

ORDER BY TotalEspacio_MB desc

post de : https://es.stackoverflow.com/questions/315885/espacio-utilizado-por-la-tablas-en-sql-server


No comments:

Post a Comment