06-09-2022 03:16 AM
HI,
I have email and file archiving server, most of time the below message will show in admin console that EV mail archiving DB have database fragmentation levels, may I know which table meet fragmentation levels and fix it?
================================================================================
Database fragmentation levels
41561 Index fragmentation was detected after scan at '6/6/2022 5:07 AM'. Disregard this warning if you have defragmented the listed indexes since.
Fragmentation warning for indexes of 'EVMAILVault_6' on SQL server instance 'EVDB1'.
1 table(s) have one or more indexes with a fragmentation level of more than 30%.
The 'EVMAILVault_6' database is crucial to the operation of Enterprise Vault.
06-09-2022 04:37 AM
Hi,
you can use this one here for example:
USE <Database>
SELECT OBJECT_NAME(i.object_ID) AS TableName,
i.name AS TableIndexName, phystat.avg_fragmentation_in_percent
FROM sys.dm_db_index_physical_stats(DB_ID(),Null,NULL,NULL, 'Limited') phystat
Join sys.indexes i on i.object_id = phystat.object_id AND i.index_id = phystat.index_id
WHERE phystat.avg_fragmentation_in_percent > 30 AND phystat.page_count > 1000
Regards
Marc
06-09-2022 04:02 PM