SQL Server Page Splits per Second

A page split typically occurs when an INSERT or UPDATE statement is adding data to a page but there is no space left to do so. In this case, SQL Server creates a new page and moves some of the data to it, thus a splitting of the page. This is a fairly normal process to occur when data is being added to the database. However, too many page splits can cause fragmentation and can hurt performance.

Page Splits / sec

This custom metric allows DPA to collect the data so it can be correlated to other metrics and performance data.

Note that this is a delta metric, meaning DPA will take 2 values from the query and use the difference as the value.