private void ScanIndexFinish(object sender, RunWorkerCompletedEventArgs e)
{
taskbar.ProgressMode = TaskbarButtonProgressMode.NoProgress;
_scanDuration.Stop();
buttonOptions.Enabled =
buttonDatabases.Enabled =
buttonRefreshIndex.Enabled =
buttonNewConnection.Enabled =
buttonRestoreDefaultLayout.Enabled = true;
buttonStopScan.Visibility = BarItemVisibility.Never;
List <Index> indexes = _scanIndexes.Where(_ => _.Fragmentation >= Settings.Options.FirstThreshold &&
_.PagesCount >= Settings.Options.MinIndexSize.PageSize() &&
_.PagesCount <= Settings.Options.MaxIndexSize.PageSize())
.OrderByDescending(_ => Math.Ceiling(Math.Truncate(_.Fragmentation ?? 0) / 20) * 20)
.ThenByDescending(_ => _.PagesCount).ToList();
QueryEngine.UpdateFixType(indexes);
QueryEngine.FindDublicateIndexes(indexes);
QueryEngine.FindUnusedIndexes(indexes);
labelIndex.Caption = indexes.Count.ToString();
labelError.Caption = _errors.ToString();
Output.Current.Add($"Processed: {_scanIndexes.Count}. Fragmented: {indexes.Count}", null, _scanDuration.ElapsedMilliseconds);
gridView1.CustomDrawEmptyForeground += CustomDrawEmptyForeground;
gridControl1.DataSource = indexes;
}
private void ScanIndexesFinish(object sender, RunWorkerCompletedEventArgs e)
{
taskbar.ProgressMode = TaskbarButtonProgressMode.NoProgress;
buttonOptions.Enabled =
buttonDatabases.Enabled =
buttonRefreshIndex.Enabled =
buttonNewConnection.Enabled = true;
buttonStopScan.Visibility = BarItemVisibility.Never;
List <Index> indexes = _indexes.Where(_ => _.Fragmentation >= (Settings.Options.SkipOperation == IndexOp.IGNORE ? Settings.Options.FirstThreshold : 0) &&
_.PagesCount >= Settings.Options.MinIndexSize.PageSize() &&
_.PagesCount <= Settings.Options.MaxIndexSize.PageSize())
.OrderBy(_ => _.Fragmentation < Settings.Options.FirstThreshold &&
Settings.Options.SkipOperation != Settings.Options.FirstOperation
? 3
: _.Fragmentation < Settings.Options.SecondThreshold &&
Settings.Options.FirstOperation != Settings.Options.SecondOperation
? 2 : 1)
.ThenByDescending(_ => (_.Fragmentation + 0.1) * _.PagesCount).ToList();
QueryEngine.UpdateFixType(indexes);
QueryEngine.FindDublicateIndexes(indexes);
QueryEngine.FindUnusedIndexes(indexes);
_ps.Indexes = _ps.IndexesTotal = indexes.Count;
_ps.IndexesSize = indexes.Sum(_ => _.PagesCount);
_ps.SavedSpace = indexes.Sum(_ => _.UnusedPagesCount);
UpdateProgressStats();
Output.Current.Add($"Processed: {_indexes.Count}. Fragmented: {_ps.Indexes}{(_ps.Indexes == 0 ? ". No indexes found. Try searching again or change settings..." : string.Empty)}");
grid.DataSource = indexes;
}
private void ScanIndexesFinish(object sender, RunWorkerCompletedEventArgs e)
{
taskbar.ProgressMode = TaskbarButtonProgressMode.NoProgress;
buttonOptions.Enabled =
buttonDatabases.Enabled =
buttonRefreshIndex.Enabled =
buttonNewConnection.Enabled = true;
buttonStopScan.Visibility = BarItemVisibility.Never;
var o = Settings.Options;
List <Index> indexes = _indexes.Where(_ => _.Fragmentation >= (o.SkipOperation == IndexOp.IGNORE ? o.FirstThreshold : 0) &&
_.PagesCount >= o.MinIndexSize.PageSize() &&
_.PagesCount <= o.MaxIndexSize.PageSize())
.OrderBy(_ => _.Fragmentation < o.FirstThreshold && o.SkipOperation != o.FirstOperation
? 3
: _.Fragmentation < o.SecondThreshold && o.FirstOperation != o.SecondOperation
? 2 : 1)
.ThenByDescending(_ => (_.Fragmentation + 0.1) * _.PagesCount).ToList();
QueryEngine.UpdateFixType(indexes);
QueryEngine.FindDublicateIndexes(indexes);
QueryEngine.FindUnusedIndexes(indexes);
if (o.StatsIgnoreHoursEnabled || o.StatsIgnoreSampledPercentEnabled)
{
indexes.RemoveAll(_ => _.IndexStats != null &&
(
_.FixType == IndexOp.UPDATE_STATISTICS_FULL ||
_.FixType == IndexOp.UPDATE_STATISTICS_RESAMPLE ||
_.FixType == IndexOp.UPDATE_STATISTICS_SAMPLE
) &&
(
(
!o.StatsIgnoreHoursEnabled
||
(o.StatsIgnoreHoursEnabled && (DateTime.UtcNow - (DateTime)_.IndexStats).TotalHours < o.StatsIgnoreHours)
)
||
(
!o.StatsIgnoreSampledPercentEnabled
||
(o.StatsIgnoreSampledPercentEnabled && _.StatsSampled > o.StatsIgnoreSampledPercent)
)
)
);
}
_ps.Indexes = _ps.IndexesTotal = indexes.Count;
_ps.IndexesSize = indexes.Sum(_ => _.PagesCount);
_ps.SavedSpace = indexes.Sum(_ => _.UnusedPagesCount);
UpdateProgressStats();
Output.Current.Add($"Processed: {_indexes.Count}. Fragmented: {_ps.Indexes}{(_ps.Indexes == 0 ? ". No indexes found. Try searching again or change settings..." : string.Empty)}");
grid.DataSource = indexes;
}
