Brentozar iconBrentozarSep 22, 2026

Database Animations: Stop Using Page Splits to Justify Lowering Fill Factor.

You're looking at page split numbers in a monitoring tool or Perfmon, and you've heard that page splits are bad, so you're lowering fill factor, expecting your page splits to go down.

Database Animations: Stop Using Page Splits to Justify Lowering Fill Factor.

Share this story

Send the public story page.

Useful takeaways from this story.

You're looking at page split numbers in a monitoring tool or Perfmon, and you've heard that page splits are bad, so you're lowering fill factor, expecting your page splits to go down.

Building the complete brief

The page is ready to read now. The fuller skim-friendly version will appear here automatically.

The useful part

You're looking at page split numbers in a monitoring tool or Perfmon, and you've heard that page splits are bad, so you're lowering fill factor, expecting your page splits to go down.

Keep reading in the app

Open the app view to save this story, compare related coverage, and continue from the same source.

Open in app