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.
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.
Do you wish to keep yourself updated about our upcoming events and webinars? We have quite a few useful resources, links and social channels. Click Here.
Get new content directly in your inbox – Click here