Browse by Tags

• Extended Events
• SQL Server 2008
• SQL Server 2008 R2

• An XEvent a Day (31 of 31) – Event Session DDL Events

  To close out this month’s series on Extended Events we’ll look at the DDL Events for the Event Session DDL operations, and how those can be used to track changes to Event Sessions and determine all of the possible outputs that could exist from an Extended Read More... Posted Friday, December 31, 2010 3:00 PM by Jonathan Kehayias | 1 Comments Filed under: Extended Events, SQL Server 2008, SQL Server 2008 R2, XEvent A Day, SQL Server Denali

• An XEvent a Day (30 of 31) – Tracking Session and Statement Level Waits

  While attending PASS Summit this year, I got the opportunity to hang out with Brent Ozar ( Blog | Twitter ) one afternoon while he did some work for Yanni Robel ( Blog | Twitter ).  After looking at the wait stats information, Brent pointed out some Read More... Posted Thursday, December 30, 2010 10:00 PM by Jonathan Kehayias | 0 Comments Filed under: Extended Events, SQL Server 2008, SQL Server 2008 R2, XEvent A Day, SQL Server Denali

• An XEvent a Day (29 of 31) – The Future – Looking at Database Startup in Denali

  As I have said previously in this series, one of my favorite aspects of Extended Events is that it allows you to look at what is going on under the covers in SQL Server, at a level that has never previously been possible. SQL Server Denali CTP1 includes Read More... Posted Wednesday, December 29, 2010 10:30 PM by Jonathan Kehayias | 0 Comments Filed under: Extended Events, SQL Server 2008, SQL Server 2008 R2, XEvent A Day, SQL Server Denali

• An XEvent a Day (28 of 31) – Tracking Page Compression Operations

  The Database Compression feature in SQL Server 2008 Enterprise Edition can provide some significant reductions in storage requirements for SQL Server databases, and in the right implementations and scenarios performance improvements as well.  There Read More... Posted Tuesday, December 28, 2010 10:00 PM by Jonathan Kehayias | 0 Comments Filed under: Extended Events, SQL Server 2008, SQL Server 2008 R2, XEvent A Day, SQL Server Denali

• An XEvent a Day (27 of 31) – The Future - Tracking Page Splits in SQL Server Denali CTP1

  Nearly two years ago Kalen Delaney blogged about Splitting a page into multiple pages , showing how page splits occur inside of SQL Server.  Following her blog post, Michael Zilberstein wrote a post, Monitoring Page Splits with Extended Events , Read More... Posted Monday, December 27, 2010 10:00 PM by Jonathan Kehayias | 2 Comments Filed under: Extended Events, SQL Server 2008, SQL Server 2008 R2, XEvent A Day, SQL Server Denali

• An XEvent a Day (26 of 31) – Configuring Session Options

  There are 7 Session level options that can be configured in Extended Events that affect the way an Event Session operates.  These options can impact performance and should be considered when configuring an Event Session.  I have made use of Read More... Posted Sunday, December 26, 2010 10:00 PM by Jonathan Kehayias | 0 Comments Filed under: Extended Events, SQL Server 2008, SQL Server 2008 R2, XEvent A Day, SQL Server Denali

• An XEvent a Day (25 of 31) – The Twelve Days of Christmas

  Correction: I mistakenly stated that Tim Mitchel had blogged the 12 days of SQL Christmas, and was informed that Tim Ford is who wrote that blog post. My sincerest apologies to Tim and Tim for the mix up. The post has been corrected below. In the spirit Read More... Posted Saturday, December 25, 2010 10:00 AM by Jonathan Kehayias | 0 Comments Filed under: Extended Events, SQL Server 2008, SQL Server 2008 R2, XEvent A Day, SQL Server Denali

• An XEvent a Day (24 of 31) – What is the package0.callstack Action?

  One of the actions inside of Extended Events is the package0.callstack and the only description provided by sys.dm_xe_objects for the object is 16-frame call stack. If you look back at The system_health Session blog post, you’ll notice that the package0.callstack Read More... Posted Friday, December 24, 2010 10:00 PM by Jonathan Kehayias | 0 Comments Filed under: Extended Events, SQL Server 2008, SQL Server 2008 R2, XEvent A Day, SQL Server Denali

• An XEvent a Day (23 of 31) – How it Works – Multiple Transaction Log Files

  While working on yesterday’s blog post The Future – fn_dblog() No More? Tracking Transaction Log Activity in Denali I did a quick Google search to find a specific blog post by Paul Randal to use it as a reference, and in the results returned another blog Read More... Posted Thursday, December 23, 2010 3:48 PM by Jonathan Kehayias | 1 Comments Filed under: Extended Events, SQL Server 2008, SQL Server 2008 R2, XEvent A Day, SQL Server Denali

• An XEvent a Day (22 of 31) – The Future – fn_dblog() No More? Tracking Transaction Log Activity in Denali

  I bet that made you look didn’t it?  Worry not, fn_dblog() still exists in SQL Server Denali, and I plan on using it to validate the information being returned by a new Event in SQL Server Denali CTP1, sqlerver.transaction_log, which brings with Read More... Posted Wednesday, December 22, 2010 11:00 AM by Jonathan Kehayias | 1 Comments Filed under: Extended Events, SQL Server 2008, SQL Server 2008 R2, XEvent A Day, SQL Server Denali

• An XEvent a Day (21 of 31) – The Future – Tracking Blocking in Denali

  One of my favorite features that was added to SQL Server 2005 has been the Blocked Process Report trace event which collects an XML report whenever a process is blocked inside of the database engine longer than the user configurable threshold.  I Read More... Posted Tuesday, December 21, 2010 10:52 PM by Jonathan Kehayias | 0 Comments Filed under: Extended Events, SQL Server 2008, SQL Server 2008 R2, XEvent A Day, SQL Server Denali

• An XEvent a Day (20 of 31) – Mapping Extended Events to SQL Trace

  One of the biggest problems that I had with getting into Extended Events was mapping the Events available in Extended Events to the Events that I knew from SQL Trace. With so many Events to choose from in Extended Events, and a different organization Read More... Posted Monday, December 20, 2010 5:24 PM by Jonathan Kehayias | 0 Comments Filed under: Extended Events, SQL Server 2008, SQL Server 2008 R2, XEvent A Day, SQL Server Denali Attachment(s): CREATE xe_trace_event_map View.zip

• An XEvent a Day (19 of 31) – Using Customizable Fields

  Today’s post will be somewhat short, but we’ll look at Customizable Fields on Events in Extended Events and how they are used to collect additional information.  Customizable Fields generally represent information of potential interest that may be Read More... Posted Sunday, December 19, 2010 10:15 PM by Jonathan Kehayias | 0 Comments Filed under: Extended Events, SQL Server 2008, SQL Server 2008 R2, XEvent A Day, SQL Server Denali

• An XEvent a Day (18 of 31) – A Look at Backup Internals and How to Track Backup and Restore Throughput (Part 2)

  In yesterday’s blog post A Look at Backup Internals and How to Track Backup and Restore Throughput (Part 1) , we looked at what happens when we Backup a database in SQL Server. Today, we are going to use the information we captured to perform some analysis Read More... Posted Saturday, December 18, 2010 10:15 PM by Jonathan Kehayias | 0 Comments Filed under: Extended Events, SQL Server 2008, SQL Server 2008 R2, XEvent A Day, SQL Server Denali

• An XEvent a Day (17 of 31) – A Look at Backup Internals and How to Track Backup and Restore Throughput (Part 1)

  Today’s post is a continuation of yesterday’s post How Many Checkpoints are Issued During a Full Backup? and the investigation of Database Engine Internals with Extended Events.  In today’s post we’ll look at how Backup’s work inside of SQL Server Read More... Posted Friday, December 17, 2010 6:00 PM by Jonathan Kehayias | 1 Comments Filed under: Extended Events, SQL Server 2008, SQL Server 2008 R2, XEvent A Day, SQL Server Denali