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
Related Courses
-
Think Like a Terminator - Internals of Classic SQL Server Indexes
-
DBA Mythbusters
-
Log Shipping in SQL Server - High Availability and Disaster Recovery
-
Neutralize Troublesome SQL Server Indexes - Fun Stories & Demos
-
Getting the Most Out of the SQL Server Maintenance Solution
-
Cross-Platform SQL Server Management - Taming Infrastructure and Application Usage
