Monitoring page splits in SQL Server is useful. It can be very
useful, for example, in order to choose the appropriate fill factor for an
index. By monitoring the number of page splits for a particular index over a
period of time, we can determine whether the fill factor for that index should
be adjusted in order to reduce the number of page splits and improve the
overall performance.

In this session we are going to demonstrate all the possible options
to monitor page splits in SQL Server, and we are going to show that all of these
options are wrong. SQL Server is lying, and we're going to prove it. We will
then demonstrate the only (documented) method to correctly monitor page splits
in SQL Server as of today.
(no tags)
The video is not available to view online.