Home Dashboard Directory Help
Search

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


Status: 

Active


7
0
Sign in
to vote
Type: Suggestion
ID: 664900
Opened: 4/26/2011 7:56:22 AM
Access Restriction: Public
0
Workaround(s)
view

Description

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.
Details
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:

http://connect.microsoft.com/SQLServer/feedback/details/388403/include-page-split-information-in-sys-dm-db-index-physical-stats
Sign in to post a workaround.