RE: Index and Page Split – SQLServerCentral

SSChampion

Points: 12120

August 3, 2014 at 6:04 am

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 ?