Please add page splits data per index, index level and page split type - by Michael Zilberstein

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 664900 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 4/26/2011 7:56:22 AM
Access Restriction Public


Currently besides PerfMon PageSplits/sec counter and page_split event in Extended Events we don't have any way of monitoring page splits. It would be extremely helpful to have this info in sys.dm_db_index_operational_stats DMF. Also it would be very helpful to distinguish between split types like it is already implemented in extended events page_split event in Denali. Split at 50:50 rate and allocation of a new page have entire different meaning for performance, so counting them together is misleading.
Sign in to post a comment.
Posted by Microsoft on 5/4/2011 at 2:55 PM
Thanks for your input, the storage engine team is looking into this.
Posted by Michael Zilberstein on 4/26/2011 at 3:16 PM
Aaron, I completely missed your item - it makes mine almost redundant.
Posted by AaronBertrand on 4/26/2011 at 10:37 AM
You've added some more useful information to the request, but see the following item: