Tag Info

New answers tagged


Its clearly visible that page_count for all the indexes shown in figure you attached is < 1500. In such case even if index is fragmented to 100% this is NOT going to cause any performance issue. Actually below is recommendation on fragmentation from Microsoft if you read BOL 2000 version Fragmentation affects disk I/O. Therefore, focus on the larger ...


Yes, that's what it looks like. Unless there is some error happening with the data after it got moved to Excel. However, these are all tiny, tiny tables. Stop caring about fragmentation on tables with less than, say, 1,000 pages.* And even then you probably shouldn't care too much until another order or two of magnitude, and even less if you are using SSD ...

Top 50 recent answers are included