SupportSQL

PageSplits are correlated here to the DiskQueue peaks (light-blue) and high wait timeouts (red). Page splits can happen for various reasons, here being that index pages did not have sufficient padding as well as the network i/o packet size was too small for several LOB data type traffic peaks. Increasing the packet size and the index padding to resolved this.

--by Alek Kirstein – SupportSQL.com