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.
Keywords: Page Splits, Extended Events
Important Links:
Follow SQLMaestros on Twitter |
|
Follow Amit Bansal on Twitter |
|
Subscribe To Newsletter |
|
SQLMaestros Video Courses |
|
SQLMaestros Hands-On-Labs |
|
Subscribe to Amit Bansal’s exclusive distribution list |
|
Join us on Telegram |
Leave A Comment