Fragmentation %
What is the impact of fragmentation when my tables fragmentation is 99% but page count is
January 22nd, 2015 9:22am

You dont have to worry about fragmentation where page count is less than 1000.

Check this - http://social.technet.microsoft.com/wiki/contents/articles/28182.sql-server-in-depth-what-can-cause-index-to-be-still-fragmented-after-rebuild.aspx

Free Windows Admin Tool Kit Click here and download it now
January 22nd, 2015 9:26am
No really a need to take care about indexes with page count less then 1000; the impact of fragmentation is only less (300 pages = 2.3 MB)
January 22nd, 2015 9:26am
We are using custom script to update\rebuild indexes and have ignored anything below 1000 pages.
Free Windows Admin Tool Kit Click here and download it now
January 22nd, 2015 9:33am
What is the impact of fragmentation when my tables fragmentation is 99% but page count is
January 22nd, 2015 10:22am

Thanks for all your time .

What  I understood from my experience . These tables are even highly used in many places all the data comes in buffer /memory  (because of the smaller size of table ) that's why there is no impact on performance .

Free Windows Admin Tool Kit Click here and download it now
June 24th, 2015 8:26pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics