New answers tagged fragmentation
14
First and foremost you should assess the impact of fragmentation. Much too often fragmentation is painted as the ultimate evil cause of all the server problems w/o any consideration of its actual impact. Fragmentation impacts several aspects:
Slow down scans due to impact on read-ahead efficiency and small IO size (page vs. extent)
Less efficient IO due to ...
0
It may also be worth checking that the new records are created with an adequate default size.
You do not want new pages allocating 10 bytes per record and then the application populating them with 100bytes worth of stuff.
This would be forcing page splits right/centre/left. It could be avoided by finding the average record size and having default values of ...
Top 50 recent answers are included
