November 2012
Intermediate to advanced
576 pages
17h 2m
English
book
Professional SQL Server 2012 Internals and Troubleshooting
by Christian Bolton, James Rowland-Jones, Glenn Berry, Justin Langford, Gavin Payne, Amit Banerjee
Content preview from Professional SQL Server 2012 Internals and TroubleshootingBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 13
Diagnosing SQL Server 2012 Using Extended Events
WHAT’S IN THIS CHAPTER?
- Introduction to Extended Events
- Why you should start using Extended Events
- Creating Extended Events sessions in SQL Server 2012
- Viewing data captured by Extended Events
WROX.COM CODE DOWNLOADS FOR THIS CHAPTER
There are no code downloads for this chapter.
INTRODUCTION TO EXTENDED EVENTS
If you’re familiar with recent versions of SQL Server, then it’s likely you’ll have heard of Extended Events, also known as XE or XEvents, and you know that it’s a diagnostics feature built into the database engine. For most people, however, their knowledge of it is not much more than that. The lack of a need to use it and a challenging command set in the first release in SQL Server 2008 meant that learning to use it was often a low priority on people’s “to do” list.
Fortunately, SQL Server 2012 should change that, as not only has the product’s documentation made it clear that Extended Events is set to become one of SQL Server’s primary diagnostic tools in future versions, but also, and perhaps more important, a graphical user interface for it is now part of SQL Server Management Studio. No longer does a complex set of T-SQL commands need to be understood before you can use the feature.
The objective of this chapter is to introduce you to the Extended Events feature in SQL Server 2012 using its new graphical user interface. After reviewing how Extended Events work and the terminology it uses, you’ll see how easy ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.