Hi Gail,

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....