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.
SSG YouTube Channel |
|
SSG Blogs |
|
Telegram Group & Channel |
|
Facebook Group |
|
Facebook Page (DPG): |
|
LinkedIn Group |
|
Twitter (SSG) |
|
Subscribe |