Michael Zilberstein : ExtendedEvents

Page splits, extended events, index page allocation and all the fish

Michael Zilberstein — Mon, 25 Apr 2011 19:49:45 GMT

2 years ago I wrote about monitoring page splits with Extended Events . Only 2 bloggers explored Extended Events feature at that time, so my post was more of a learning than for any practical matter. Yet one question remained open: according to straightforward...(read more)

Parsing Extended Events xml_deadlock_report

Michael Zilberstein — Mon, 10 May 2010 01:31:00 GMT

Jonathan Kehayias and Paul Randall posted more than a year ago great articles on how to monitor historical deadlocks using Extended Events system_health default trace. Both tried to fix on the fly bug in xml output that caused failures in xml validation....(read more)

Monitoring page splits with Extended Events

Michael Zilberstein — Thu, 05 Feb 2009 15:05:12 GMT

After reading Kalen Delaney's post about single insert causing 10 page splits, I wanted to see those splits in detail - their order at first place. And in SQL Server 2008 there is a way to trace splits - using new Extended Events infrastructure. Here...(read more)