Skip to content

Instantly share code, notes, and snippets.

View apeterson-BFI's full-sized avatar

Anthony Peterson apeterson-BFI

1 follower · 1 following
  • Burnette Foods, Inc.
  • Traverse City, MI
View GitHub Profile
@apeterson-BFI
apeterson-BFI / query2.csv
Created February 7, 2017 15:47
1429580131 NULL NULL 2 NONCLUSTERED INDEX 0 99.446704637917 48.3434642945392 18435
85575343 NULL NULL 2 NONCLUSTERED INDEX 0 99.2857142857143 56.5833703978256 140
1429580131 NULL NULL 7 NONCLUSTERED INDEX 0 99.2558043828664 60.7563627378305 29159
315148168 NULL NULL 2 NONCLUSTERED INDEX 0 99.235547061634 57.7584754138868 2093
2130106629 NULL NULL 2 NONCLUSTERED INDEX 0 99.2097701149425 58.632876204596 1392
1429580131 NULL NULL 4 NONCLUSTERED INDEX 0 99.1877830594752 57.5127131208302 26717
1438628168 NULL NULL 2 NONCLUSTERED INDEX 0 99.1785965735743 74.5238942426489 4261
898102240 NULL NULL 2 NONCLUSTERED INDEX 0 99.0733876945886 50.9609093155424 2698
1374627940 NULL NULL 4 NONCLUSTERED INDEX 0 99.009900990099 54.0733135656041 101
1374627940 NULL NULL 5 NONCLUSTERED INDEX 0 99.009900990099 54.0733135656041 101
@apeterson-BFI
apeterson-BFI / query.csv
Created February 7, 2017 15:38
New Query
85575343 NULL NULL 2 NONCLUSTERED INDEX 0 99.2857142857143 56.5833703978256 140
1429580131 NULL NULL 7 NONCLUSTERED INDEX 0 99.2558043828664 60.7563627378305 29159
315148168 NULL NULL 2 NONCLUSTERED INDEX 0 99.235547061634 57.7584754138868 2093
2130106629 NULL NULL 2 NONCLUSTERED INDEX 0 99.2097701149425 58.632876204596 1392
1429580131 NULL NULL 4 NONCLUSTERED INDEX 0 99.1877830594752 57.5127131208302 26717
1438628168 NULL NULL 2 NONCLUSTERED INDEX 0 99.1785965735743 74.5238942426489 4261
898102240 NULL NULL 2 NONCLUSTERED INDEX 0 99.0733876945886 50.9609093155424 2698
1374627940 NULL NULL 4 NONCLUSTERED INDEX 0 99.009900990099 54.0733135656041 101
1374627940 NULL NULL 5 NONCLUSTERED INDEX 0 99.009900990099 54.0733135656041 101
@apeterson-BFI
apeterson-BFI / fragresults.txt
Created February 7, 2017 14:48
Fragmentation results
OBJECT_ID index_id index_type_desc index_level avg_fragmentation_in_percent avg_page_space_used_in_percent page_count
1429580131 2 NONCLUSTERED INDEX 0 99.446704637917 48.331504818384 18435
85575343 2 NONCLUSTERED INDEX 0 99.2857142857143 56.5833703978256 140
1429580131 7 NONCLUSTERED INDEX 0 99.2558043828664 60.7504694835681 29159