WhiteLotus (8/3/2014)
GilaMonster (8/3/2014)
murnilim9 (7/30/2014)
Moreover , I noticed the PAGE SPLIT/Sec is still high ..around 90 . How do i know which table that cause that page split ?That counter is misleading. It is not the number of mid-index page splits (which are the ones which cause fragmentation)
Hi..
Thx for your response ...I wonder what do you mean by mid-index page splits ?
Page splits which occur in the middle (anywhere other than the ends) of an index, resulting in fragmentation.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability