Databases Reference
In-Depth Information
CREATING EXTENDED EVENTS SESSIONS IN SQL SERVER 2012
By now you should have a good understanding of Extended Events terminology, how it works,
and its features. Space doesn't permit covering every internal detail, capability, or feature, but you
should be able to start deploying your own sessions through SQL Server Management Studio based
on the examples shown here.
This section uses the new capabilities of SQL Server 2012's Management Studio to create Extended
Events sessions. If you're interested in using the T-SQL commands, you'll also see how the SSMS
interface can help you get started using the T-SQL commands.
Introduction to the New Session Form
SQL Server Management Studio provides two ways to create a
new session: a New Session Wizard and a New Session creation
form, as shown in Figure 13-5.
While the wizard option may appeal to newcomers as an easy
way to get started, it's a little too lightweight in terms of func-
tionality to be of great use, and using the more thorough New
Session creation form, shown in Figure 13-6, isn't much more
complicated. We recommend ignoring the wizard when you begin
creating your own sessions.
FIGURE 13-5
FIGURE 13-6
Search WWH ::
Custom Search