WhiteLotus (8/3/2014) GilaMonster (8/3/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)
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.
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass