Friday, April 15, 2011

How to find Page Splits by Table/Index

This script provided information on which Table/Index was performing the page split.  I'm surprised there's apparrantly no DMV for this information.  Sorry, I do not have a reference from where I originally got this.

select AllocUnitName, count([AllocUnitName]) [Splits]
from ::fn_dblog(null, null)
where Operation = N'LOP_DELETE_SPLIT' and parsename(AllocUnitName,3) <> 'sys'
group by AllocUnitName

No comments:

Post a Comment