Getting Started with Adobe After Effects - Part 6: Motion Blur

Upload Image Close it
Select File

Career advice for the IT professional
Browse by Tags · View All
SQLServerPedia Syndication 194
SQL Server 60
2012/Denali 17
Career 17
Denali 14
SQL Server 2012 13

Archive · View All
June 2011 20
August 2011 15
July 2011 15
March 2012 15
October 2011 14
September 2011 14
May 2011 13
November 2011 12
February 2012 11
April 2012 10

James Serra's Blog

SQL Server 2012 (“Denali”): Extended Events

Feb 29 2012 12:00AM by James Serra   

Extended Events is a general event-handling system for performance monitoring that was introduced in SQL Server 2008.  It has a highly scalable and highly configurable architecture that allows users to collect as much or as little information as is necessary to troubleshoot or identify a performance problem.

While there are already a number of diagnostics tools such as DBCC, SQL Trace, SQL Server Profiler, DMVs, and Perfmon, Extended Events offer several major advantages:  It is light weight, has a highly scalable and highly configurable architecture, it allows a deeper and more granular level control of tracing, and it has more events that can be captured (for example you can identify page splits and high CPU utilization by ad-hoc queries).  For further troubleshooting, you can even use Extended Events to correlate SQL Server captured event data.  For more info see Opening the SQL Server 2008 Toolbox – An Introduction to Extended Events.

In SQL Server 2012, the following features were added:

  • Ported the complete set of diagnostic events that are available in SQL Trace over to Extended Events and rounded out the set of Actions to ensure that you can produce the same data from an event session that you can using SQL Trace
  • Added a user interface.  The Extended Events user interface is built directly into SSMS and there are four primary pieces: Session list, New Session Wizard, New Session dialog, Extended Events display
  • Introduced a “management” API for Extended Events that gives you access to the “inventory” of the system (eg. lists of events, actions, etc.) as well as the ability to create, modify and delete sessions using your favorite managed language.   This API is exposed through PowerShell
  • A “reader” API that provides functionality for reading event files (XEL) and event streams coming from a running event session

Note that with SQL Server 2012, SQL Trace is deprecated.  It will be phased out over the next few released in favor of Extended Events.

More info:

SQL Server 2012 “Denali”: Extended Discussion On Usage Scenario for “Extended Events” (Part-1)

SQL Server 2012 Extended Events Update – 1- Introducing the SSMS User Interface

SQL Server 2012 Extended Events Update – 2 – The SSMS UI Part 2

What’s New for Extended Events in SQL Server Codenamed “Denali” CTP3

Introducing the Extended Events User Interface

Introducing the Extended Events Reader

Introducing the Extended Events Object Model

What’s new for Extended Events in SQL Server code-named “Denali” CTP1

Republished with author's permission. See the original post here.

Republished from James Serra's Blog [70 clicks].  Read the original version here [32134 clicks].

James Serra
35 · 5% · 1664


Your Comment

Sign Up or Login to post a comment.

    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]