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?
Jason Hall replied: Hey Ken, The collection that drives the Fragmentation data is called "Fragmentation Overview".
Ken replied: Found it: It is not the "Index Fragmentation" but the "Fragmentation Overview" schedule that I am interested in.