Avg. Bytes Free per Page-每页上的平均可用字节数:所扫描的页上的平均可用字节数。越高说明有内部碎片,不过在你用这个数字决定是否有内部碎片之前,应该考虑fill factor(填充因子)。
Avg. Page Density (full)-平均页密度(完整):每页上的平均可用字节数的百分比的相反数。低的百分比说明有内部碎片
通过sql server 代理创建定时任务定期来重建索引
DECLARE @TABLENAME NVARCHAR(MAX)
IF(CURSOR_STATUS('global','TABLE_CURSOR')<>'-3')
BEGIN
CLOSE TABLE_CURSOR
DEALLOCATE TABLE_CURSOR
END
DECLARE TABLE_CURSOR CURSOR FOR SELECT NAME FROM SYS.objects WHERE TYPE = 'U' AND name LIKE 'T_HIS%' ORDER BY modify_date DESC
OPEN TABLE_CURSOR
FETCH NEXT FROM TABLE_CURSOR INTO @TABLENAME
WHILE (@@FETCH_STATUS = 0)
BEGIN
dbcc dbreindex (@TABLENAME,'',80)
FETCH NEXT FROM TABLE_CURSOR INTO @TABLENAME
END
CLOSE TABLE_CURSOR
DEALLOCATE TABLE_CURSOR