Even with the fastest of CPUs and Storage, Page Splits are still very bad. Also leads to fragmentation. Here is a quick video that shows how you can capture page splits using extended events.
Get new content directly in your inbox – Click here
You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and to download video resources (presentation & demo code).
Hope the video was worth your time.
Happy Learning.
Learn more about SQLMaestros Products & Services: Video Courses| Hands-On-Labs | Learning Kits | Health Check Service
Leave A Comment