Querying DMV, sys.dm db index operational stats, I can see some leaf allocation count and non leaf allocation count for these primary keys. In most of site, it refers a page split.
Answering your question"Why do you bother about page splits"
1. I would like to know the reason for the above count to understand the DMV. If the above are no way related to page splits, I would be able to take this DMV from my list to check the Page splits.
2. Even its not big; not claiming my db is perfect
, as long as these primary keys are no way in use of read operations, changing the fillfactor would benefit? I am curious to know the fact on the same.
3. Again, its small, if i could give some improvements in updates, if at al there any page splits, I would feel that I learnt something...
Thanks for your effort making me understand the things so far....