Disabled Index

This warning has been raised because a disabled index has been found. Either enable the index if it was disabled unintentionally or drop the index.

To rebuild and enable a disabled index, use the ALTER INDEX REBUILD statement or the CREATE INDEX WITH DROP_EXISTING statement.

Suggested Action

The index isn't currently being used, therefore dropping will not alter how the instance is behaving.

Any suggestion from Aireforge should be thoroughly tested before being implemented into production.

Further Reading

Disabling Indexes | Microsoft Docs