Extended Events were introduced in SQL Server 2008. With SQL 2014, we have seen a significant upgrade to this feature. Join me for a little adventure into the realm of extended events. We will discuss how to use extended events to aid in performance tuning and in day to day administration. We will also explore some background and the architecture of extended events. This is a fast paced session and will be a lot of fun. Attendees will be able to take back several sample XE sessions to help troubleshoot different issues and get to more intimately know their data/environment.
Come one, come all!! Oh wait, it’s too late now. I just finished giving my presentation to the DBA VC (virtual chapter). There was good attendance and there were good questions asked. My presentation was the very same presentation that I gave for SQLSat83 (sheepishly: I even used the same slidedeck).
The presentation was recorded and I will post the link for that when it becomes available. There was one goofup on my part. I went on for about 5 minutes without the shared application having actually switched – D’OH. My sincerest apologies for that.
During the presentation I made references to a few resources that I felt should be noted somewhere since I didn’t provide the exact resource during the presentation.
- Paul Randal myth-a-day concerning heap rebuilds.
- Kimberly Tripp’s information on VLFs.
- 3rd party tool for documenting a database quickly – called SQLSpec. (it’s fairly inexpensive)
I really enjoyed giving this presentation and sharing my yet-to-be finished basement with everybody. I hope to be doing more of these over time.