Saber Fragmentacion de Tabla en SQL SERVER

Aqui os dejo un script para saber el procentage de fragmentacion de vuestra bbdd a nivel tabla

 SELECT
b.name as 'database',
c.name as 'name',
index_type_desc,
avg_fragmentation_in_percent,
page_count
FROM sys.dm_db_index_physical_stats (DB_ID('TUBBDD'), NULL, NULL, NULL, 'limited')AS A
LEFT JOIN SYS.DATABASES B
ON A.DATABASE_iD = B.DATABASE_ID
LEFT JOIN SYS.OBJECTS C
ON A.OBJECT_iD = C.OBJECT_iD
Order by avg_fragmentation_in_percent desc

SELECT

b.name as 'database',

c.name as 'name',

index_type_desc,

avg_fragmentation_in_percent,

page_count

FROM sys.dm_db_index_physical_stats (DB_ID('TUBBDD'), NULL, NULL, NULL, 'limited')AS A

LEFT JOIN SYS.DATABASES B

ON A.DATABASE_iD = B.DATABASE_ID

LEFT JOIN SYS.OBJECTS C

ON A.OBJECT_iD = C.OBJECT_iD

Order by avg_fragmentation_in_percent desc

Espero que os sirva

Deja un comentario Cancelar respuesta