Finding Page Splits

• Vinay Thankur

  SSCarpal Tunnel

  Points: 4178

  More actions

  May 12, 2009 at 2:31 pm

  #993277

  http://sqlblog.com/blogs/michael_zilberstein/archive/2009/02/05/11734.aspx

  hth.

  Vinay

  Thanx.
  Vinay

  http://rdbmsexperts.com/Blogs/
  http://vinay-thakur.spaces.live.com/
  http://twitter.com/ThakurVinay

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  May 12, 2009 at 3:36 pm

  #993315

  GilaMonster (5/7/2009)

  ---

  Lynn Pettis (5/7/2009)

  ---

  You can query the t-log??

  Yup. Undocumented command.

  SELECT * FROM fn_dblog(null, null)

  Dang. That's amazing, Gail. :w00t:

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

• Robert Vallee

  Right there with Babe

  Points: 786

  More actions

  November 5, 2009 at 9:10 am

  #1075429

  I use this to find page splits:

  USE <DB>

  select AllocUnitName, count([AllocUnitName]) [Splits]

  from ::fn_dblog(null, null)

  where Operation = N'LOP_DELETE_SPLIT' and parsename(AllocUnitName,3) <> 'sys'

  group by AllocUnitName

  I can't take credit, http://blogs.sqlserver.org.au/blogs/greg_linwood/archive/2004/11/27/37.aspx

  Rob Vallee

  ISpySQL.com

• michael bourgon

  SSC Eights!

  Points: 823

  More actions

  May 18, 2010 at 8:24 am

  #1168848

  Robert Vallee (11/5/2009)

  ---

  I use this to find page splits:

  ...

  select AllocUnitName, count([AllocUnitName]) [Splits]

  from ::fn_dblog(null, null)

  where Operation = N'LOP_DELETE_SPLIT' and parsename(AllocUnitName,3) <> 'sys'

  group by AllocUnitName

  ...

  That is _awesome_. Many thanks for pointing to that!