Extended Events

We are planning to convert or change all existing Traces to Extended Events in SQL server 2012.

Please what is the procedure to convert custom traces.

We have already created some below custom traces: like this we are planning to convert for all servers.

exec sp_trace_setevent @TraceID, 20, 23, @on
exec sp_trace_setevent @TraceID, 20, 8, @on
exec sp_trace_setevent @TraceID, 20, 12, @on
exec sp_trace_setevent @TraceID, 20, 64, @on
exec sp_trace_setevent @TraceID, 20, 1, @on
exec sp_trace_setevent @TraceID, 20, 21, @on
exec sp_trace_setevent @TraceID, 20, 6, @on
exec sp_trace_setevent @TraceID, 20, 10, @on
exec sp_trace_setevent @TraceID, 20, 14, @on
exec sp_trace_setevent @TraceID, 20, 26, @on
exec sp_trace_setevent @TraceID, 20, 11, @on
exec sp_trace_setevent @TraceID, 20, 35, @on
exec sp_trace_setevent @TraceID, 46, 7, @on
exec sp_trace_setevent @TraceID, 46, 23, @on
exec sp_trace_setevent @TraceID, 46, 8, @on
exec sp_trace_setevent @TraceID, 46, 40, @on
exec sp_trace_setevent @TraceID, 46, 64, @on
exec sp_trace_setevent @TraceID, 46, 1, @on
exec sp_trace_setevent @TraceID, 46, 6, @on
exec sp_trace_setevent @TraceID, 46, 10, @on
exec sp_trace_setevent @TraceID, 46, 14, @on
exec sp_trace_setevent @TraceID, 46, 26, @on
exec sp_trace_setevent @TraceID, 46, 34, @on
exec sp_trace_setevent @TraceID, 46, 11, @on
exec sp_trace_setevent @TraceID, 46, 35, @on
exec sp_trace_setevent @TraceID, 46, 12, @on

May 27th, 2015 4:51pm

A small confusion  here what is 20 and 23? how to know there are belongs to which trace?

exec sp_trace_setevent @TraceID, 20, 23, @on

May 27th, 2015 6:50pm

20 and 23 are EventID and CollumnId as documented in BOL

sp_trace_setevent

David

Free Windows Admin Tool Kit Click here and download it now
May 27th, 2015 6:56pm

Hi,

All my extended events are working fine.

How can i store these information in table as we doing in profiler?

June 1st, 2015 1:04pm

CREATE EVENT SESSION MonitorUserDefinedException ON SERVER 
--Add events to this seesion with ADD EVENT clause 

ADD
 EVENT sqlserver.error_reported 
(
 
--Specify what all you want to capture event data with ACTION Clause 
ACTION 
( 
sqlserver
.session_id, 
sqlserver
.sql_text, 
sqlserver
.tsql_stack 

--Specify predicates to filter out your events 
WHERE sqlserver.error_reported.error >= 50000 

--Specify the target where event data will be written with ADD TARGET clause 

ADD
 TARGET package0.ring_buffer 
WITH 
(max_dispatch_latency = 1seconds) 
GO

refer more

http://www.mssqltips.com/sqlservertip/2155/getting-started-with-extended-events-in-sql-server-2008/

Free Windows Admin Tool Kit Click here and download it now
June 1st, 2015 6:57pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics