Posted by: bhikari September 24, 2010
Login in to Rate this Post:
0
?
what is this I/O overhead thing. As I understand if I have high I/O overhead it affects my reads correct?
I am using dbcc showcontig to find my fragmentations and doing reindexing. If I do frequent re-indexing, then it will reorganize my pagesplits correct?..
Another questions, if i have too many pagesplits then what happens? It affects my reads or writes? Seems like more pagesplits (higher fill factor)=good for reads. Less Page Splits (less fill factor, more I/O overhead)=good for writes. Please help me understand this concept.