---
title: "Reindexing - Index Fragmentation"
canonical: "https://wiki.soft1.eu/space/SS5EL/1231848029/Reindexing%20-%20Index%20Fragmentation"
format: markdown
---
---

#### <span style="color: #0747a6"> </span>➡️ <span style="color: #0747a6">Έλεγχος Index Fragmentation</span>

DECLARE @dbName nvarchar(255);  
SELECT @dbName = '<span style="color: #36b37e">db name to be checked</span>';  
SELECT  
      <u>[db.name](http://db.name/)</u> AS databaseName  
    , ps.OBJECT_ID AS objectID  
    , OBJECT_NAME ( ps.OBJECT_ID, db_id(@dbName) ) AS tableName  
    , ps.index_id AS indexID  
    , <u>[si.name](http://si.name/)</u> AS indexName  
    , ps.partition_number AS partitionNumber  
    , ps.avg_fragmentation_in_percent AS fragmentation  
    , ps.page_count  
FROM sys.databases db  
  INNER JOIN sys.dm_db_index_physical_stats (db_id(@dbName), NULL, NULL , NULL, N'Limited') ps  
      ON db.database_id = ps.database_id  
  INNER JOIN sys.indexes si ON ps.OBJECT_ID = si.OBJECT_ID AND ps.index_id = si.index_id  
WHERE ps.index_id > 0   
   AND ps.page_count > 100   
   AND ps.avg_fragmentation_in_percent > 30  
ORDER BY tableName, indexName  
OPTION (MaxDop 1);