This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

How to force Spotlight to update Index Fragmentation report

Hello everyone,

My Spotlight on SQL Server reports an index with 99% fragmentation so I used the generated script to rebuild it.  That was half an hour ago and Spotlight still shows the same index with 99% fragmentation.  Is there a way to force Spotlight on SQL Server to update its Index Fragmentation data?

Ken

Parents
  • When I follow your steps, I don't see a Background Schedule for "Index Fragmentation". There is an entry for "SQL Index Summary" that has the following settings:

    Collect in background: Not collecting

    Collect for reporting: 12:00 AM every day

    Keep for: 3 days

    Is that the one that collects the index fragmentation information?

    Ken
Reply
  • When I follow your steps, I don't see a Background Schedule for "Index Fragmentation". There is an entry for "SQL Index Summary" that has the following settings:

    Collect in background: Not collecting

    Collect for reporting: 12:00 AM every day

    Keep for: 3 days

    Is that the one that collects the index fragmentation information?

    Ken
Children
No Data