Enabling Fragmentation Manager in SQL Sentry Enabling Fragmentation Manager in SQL Sentry causes slowness on SQL instance ? does it take additional resources ?
It depends on which elements of the Fragmentation Management component you enable. There are three different levels of capability that can be enabled;


Collect Index usage stats &amp; Buffer utilization capture
Collect Index Fragmentation details
Enable Index defragmentation capability


As Erik said, if you are collecting fragmentation data then that will have an overhead because if the way that the sys.dm_db_index_physical_stats() DMF works.

Rather than go into more details on the config options and other capabilities in more depth here. Please feel free to open a support ticket with us by emailing Support@SentryOne.com or contact me directly on Jmartin@SentryOne.com.

John Q. Martin
Product Manager
SentryOne