• State Not Answered
  • Locked Locked
  • Replies 3 replies
  • Subscribers 7 subscribers
  • Views 6513 views
  • Users 0 members are here
Options
Related
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

Claudia.Coleman
over 6 years ago

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
  • 0 over 6 years ago
    Hi Ken,
    Because the Index Fragmentation collection by default runs only once a day (at 4:15AM), you won't see the reflected changes in Spotlight until the next day. This by design since this collection can cause timeout issues.
    You can view/edit the scheduled time of this collection in Spotlight by going to Configure toolbar and selecting 'Scheduling' icon. In this dialogue, first choose your connection name from drop-down list on the top. Then scroll down the list of collections to 'Fragmentation Overview' and edit it. Disable 'Factory Settings' option to change time interval of this collection.

    Hope that helps.
    Gita
Reply
  • 0 over 6 years ago
    Hi Ken,
    Because the Index Fragmentation collection by default runs only once a day (at 4:15AM), you won't see the reflected changes in Spotlight until the next day. This by design since this collection can cause timeout issues.
    You can view/edit the scheduled time of this collection in Spotlight by going to Configure toolbar and selecting 'Scheduling' icon. In this dialogue, first choose your connection name from drop-down list on the top. Then scroll down the list of collections to 'Fragmentation Overview' and edit it. Disable 'Factory Settings' option to change time interval of this collection.

    Hope that helps.
    Gita
Children
No Data