Monitoring Page Splits in SQL Server - Cross-Platform SQL Server Management

YouTube·PASS Data Community Summit

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.