Kick starting Extended Events

  • We have no prior experience of using XE.

    Yes, our DBA group uses server side traces, sp_whoisactive collections, and more.

    Yet none of us yet have dived deep enough into XE to make momentous decisions.  What would you advice we start with? what Sessions/templates/ should be the first one we launch for starters? and should exporting data to table be also scheduled as a Agent job? to avoid xml querying the XE data.  or is it automatic? We are big on historical data collections, too. Not using much 3rd party tools.

    thank you all for sharing your experiences and intellect! I always appreciate it.

    Voldemar likes to play CHESS (and IS good at it!)

  • I'd just jump in and start using XE. First, there is no way of completely avoiding the XML. It's fundamental to the process. However, I recently wrote a blog post on how to largely work your way around the XML. I have a whole slew of blog posts on the topic of extended events. Many of them cover the basics of getting started using XE appropriately.

    ----------------------------------------------------
    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
    Theodore Roosevelt

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply