Explore the intricacies of monitoring page splits in SQL Server through this comprehensive conference talk. Delve into various monitoring options, understand their limitations, and discover the only documented method for accurately tracking page splits. Learn through demonstrations, including page split demos, transaction log analysis, and event target usage. Gain insights into best practices, nonleaf level page splits, and page splits for nonclustered and secondary indexes. Enhance your SQL Server management skills with expert guidance on this critical aspect of database performance optimization.
Monitoring Page Splits in SQL Server - Cross-Platform SQL Server Management
PASS Data Community Summit via YouTube
Overview
Syllabus
Introduction
What is a page split
Page splits demo
No real page splits
Transaction Log
Transaction Log Demo
Inserting the first row
Inserting the second row
Check point
SDB Log
Change to Simple
Transactional Event
Event Targets
Long Query
Best Practice
Questions
Nonleaf level page splits
More of a comment
Page split for nonclustered indexes
Page split for secondary indexes
Outro
Taught by
PASS Data Community Summit
