forked from vincent/notebook
185 lines
14 KiB
Transact-SQL
185 lines
14 KiB
Transact-SQL
/****************************************************/
|
||
/* Created by: SQL Server 2019 Profiler */
|
||
/* Date: 26/06/2020 15:36:56 */
|
||
/****************************************************/
|
||
|
||
|
||
-- Create a Queue
|
||
declare @rc int
|
||
declare @TraceID int
|
||
declare @maxfilesize bigint
|
||
set @maxfilesize = 25
|
||
|
||
-- Please replace the text InsertFileNameHere, with an appropriate
|
||
-- filename prefixed by a path, e.g., c:\MyFolder\MyTrace. The .trc extension
|
||
-- will be appended to the filename automatically. If you are writing from
|
||
-- remote server to local drive, please use UNC path and make sure server has
|
||
-- write access to your network share
|
||
|
||
exec @rc = sp_trace_create @TraceID output, 2, N'C:\mestrace\trace', @maxfilesize, NULL
|
||
if (@rc != 0) goto error
|
||
|
||
-- Client side File and Table cannot be scripted
|
||
|
||
-- Set the events
|
||
declare @on bit
|
||
set @on = 1
|
||
exec sp_trace_setevent @TraceID, 148, 1, @on
|
||
exec sp_trace_setevent @TraceID, 148, 41, @on
|
||
exec sp_trace_setevent @TraceID, 148, 4, @on
|
||
exec sp_trace_setevent @TraceID, 148, 12, @on
|
||
exec sp_trace_setevent @TraceID, 148, 11, @on
|
||
exec sp_trace_setevent @TraceID, 148, 51, @on
|
||
exec sp_trace_setevent @TraceID, 148, 14, @on
|
||
exec sp_trace_setevent @TraceID, 148, 26, @on
|
||
exec sp_trace_setevent @TraceID, 148, 60, @on
|
||
exec sp_trace_setevent @TraceID, 148, 64, @on
|
||
exec sp_trace_setevent @TraceID, 25, 1, @on
|
||
exec sp_trace_setevent @TraceID, 25, 9, @on
|
||
exec sp_trace_setevent @TraceID, 25, 2, @on
|
||
exec sp_trace_setevent @TraceID, 25, 66, @on
|
||
exec sp_trace_setevent @TraceID, 25, 10, @on
|
||
exec sp_trace_setevent @TraceID, 25, 3, @on
|
||
exec sp_trace_setevent @TraceID, 25, 4, @on
|
||
exec sp_trace_setevent @TraceID, 25, 6, @on
|
||
exec sp_trace_setevent @TraceID, 25, 7, @on
|
||
exec sp_trace_setevent @TraceID, 25, 8, @on
|
||
exec sp_trace_setevent @TraceID, 25, 11, @on
|
||
exec sp_trace_setevent @TraceID, 25, 12, @on
|
||
exec sp_trace_setevent @TraceID, 25, 13, @on
|
||
exec sp_trace_setevent @TraceID, 25, 14, @on
|
||
exec sp_trace_setevent @TraceID, 25, 15, @on
|
||
exec sp_trace_setevent @TraceID, 25, 22, @on
|
||
exec sp_trace_setevent @TraceID, 25, 25, @on
|
||
exec sp_trace_setevent @TraceID, 25, 26, @on
|
||
exec sp_trace_setevent @TraceID, 25, 32, @on
|
||
exec sp_trace_setevent @TraceID, 25, 35, @on
|
||
exec sp_trace_setevent @TraceID, 25, 41, @on
|
||
exec sp_trace_setevent @TraceID, 25, 49, @on
|
||
exec sp_trace_setevent @TraceID, 25, 51, @on
|
||
exec sp_trace_setevent @TraceID, 25, 52, @on
|
||
exec sp_trace_setevent @TraceID, 25, 55, @on
|
||
exec sp_trace_setevent @TraceID, 25, 56, @on
|
||
exec sp_trace_setevent @TraceID, 25, 57, @on
|
||
exec sp_trace_setevent @TraceID, 25, 58, @on
|
||
exec sp_trace_setevent @TraceID, 25, 60, @on
|
||
exec sp_trace_setevent @TraceID, 25, 64, @on
|
||
exec sp_trace_setevent @TraceID, 59, 1, @on
|
||
exec sp_trace_setevent @TraceID, 59, 25, @on
|
||
exec sp_trace_setevent @TraceID, 59, 2, @on
|
||
exec sp_trace_setevent @TraceID, 59, 3, @on
|
||
exec sp_trace_setevent @TraceID, 59, 4, @on
|
||
exec sp_trace_setevent @TraceID, 59, 12, @on
|
||
exec sp_trace_setevent @TraceID, 59, 14, @on
|
||
exec sp_trace_setevent @TraceID, 59, 22, @on
|
||
exec sp_trace_setevent @TraceID, 59, 21, @on
|
||
exec sp_trace_setevent @TraceID, 59, 26, @on
|
||
exec sp_trace_setevent @TraceID, 59, 32, @on
|
||
exec sp_trace_setevent @TraceID, 59, 35, @on
|
||
exec sp_trace_setevent @TraceID, 59, 41, @on
|
||
exec sp_trace_setevent @TraceID, 59, 49, @on
|
||
exec sp_trace_setevent @TraceID, 59, 51, @on
|
||
exec sp_trace_setevent @TraceID, 59, 52, @on
|
||
exec sp_trace_setevent @TraceID, 59, 55, @on
|
||
exec sp_trace_setevent @TraceID, 59, 56, @on
|
||
exec sp_trace_setevent @TraceID, 59, 57, @on
|
||
exec sp_trace_setevent @TraceID, 59, 58, @on
|
||
exec sp_trace_setevent @TraceID, 59, 60, @on
|
||
exec sp_trace_setevent @TraceID, 59, 64, @on
|
||
exec sp_trace_setevent @TraceID, 17, 1, @on
|
||
exec sp_trace_setevent @TraceID, 17, 9, @on
|
||
exec sp_trace_setevent @TraceID, 17, 10, @on
|
||
exec sp_trace_setevent @TraceID, 17, 11, @on
|
||
exec sp_trace_setevent @TraceID, 17, 6, @on
|
||
exec sp_trace_setevent @TraceID, 17, 12, @on
|
||
exec sp_trace_setevent @TraceID, 17, 14, @on
|
||
exec sp_trace_setevent @TraceID, 10, 1, @on
|
||
exec sp_trace_setevent @TraceID, 10, 9, @on
|
||
exec sp_trace_setevent @TraceID, 10, 2, @on
|
||
exec sp_trace_setevent @TraceID, 10, 66, @on
|
||
exec sp_trace_setevent @TraceID, 10, 10, @on
|
||
exec sp_trace_setevent @TraceID, 10, 3, @on
|
||
exec sp_trace_setevent @TraceID, 10, 4, @on
|
||
exec sp_trace_setevent @TraceID, 10, 6, @on
|
||
exec sp_trace_setevent @TraceID, 10, 7, @on
|
||
exec sp_trace_setevent @TraceID, 10, 8, @on
|
||
exec sp_trace_setevent @TraceID, 10, 11, @on
|
||
exec sp_trace_setevent @TraceID, 10, 12, @on
|
||
exec sp_trace_setevent @TraceID, 10, 13, @on
|
||
exec sp_trace_setevent @TraceID, 10, 14, @on
|
||
exec sp_trace_setevent @TraceID, 10, 15, @on
|
||
exec sp_trace_setevent @TraceID, 10, 16, @on
|
||
exec sp_trace_setevent @TraceID, 10, 17, @on
|
||
exec sp_trace_setevent @TraceID, 10, 18, @on
|
||
exec sp_trace_setevent @TraceID, 10, 25, @on
|
||
exec sp_trace_setevent @TraceID, 10, 26, @on
|
||
exec sp_trace_setevent @TraceID, 10, 31, @on
|
||
exec sp_trace_setevent @TraceID, 10, 34, @on
|
||
exec sp_trace_setevent @TraceID, 10, 35, @on
|
||
exec sp_trace_setevent @TraceID, 10, 41, @on
|
||
exec sp_trace_setevent @TraceID, 10, 48, @on
|
||
exec sp_trace_setevent @TraceID, 10, 49, @on
|
||
exec sp_trace_setevent @TraceID, 10, 50, @on
|
||
exec sp_trace_setevent @TraceID, 10, 51, @on
|
||
exec sp_trace_setevent @TraceID, 10, 60, @on
|
||
exec sp_trace_setevent @TraceID, 10, 64, @on
|
||
exec sp_trace_setevent @TraceID, 12, 1, @on
|
||
exec sp_trace_setevent @TraceID, 12, 9, @on
|
||
exec sp_trace_setevent @TraceID, 12, 3, @on
|
||
exec sp_trace_setevent @TraceID, 12, 11, @on
|
||
exec sp_trace_setevent @TraceID, 12, 4, @on
|
||
exec sp_trace_setevent @TraceID, 12, 6, @on
|
||
exec sp_trace_setevent @TraceID, 12, 7, @on
|
||
exec sp_trace_setevent @TraceID, 12, 8, @on
|
||
exec sp_trace_setevent @TraceID, 12, 10, @on
|
||
exec sp_trace_setevent @TraceID, 12, 12, @on
|
||
exec sp_trace_setevent @TraceID, 12, 13, @on
|
||
exec sp_trace_setevent @TraceID, 12, 14, @on
|
||
exec sp_trace_setevent @TraceID, 12, 15, @on
|
||
exec sp_trace_setevent @TraceID, 12, 16, @on
|
||
exec sp_trace_setevent @TraceID, 12, 17, @on
|
||
exec sp_trace_setevent @TraceID, 12, 18, @on
|
||
exec sp_trace_setevent @TraceID, 12, 26, @on
|
||
exec sp_trace_setevent @TraceID, 12, 31, @on
|
||
exec sp_trace_setevent @TraceID, 12, 35, @on
|
||
exec sp_trace_setevent @TraceID, 12, 41, @on
|
||
exec sp_trace_setevent @TraceID, 12, 48, @on
|
||
exec sp_trace_setevent @TraceID, 12, 49, @on
|
||
exec sp_trace_setevent @TraceID, 12, 50, @on
|
||
exec sp_trace_setevent @TraceID, 12, 51, @on
|
||
exec sp_trace_setevent @TraceID, 12, 60, @on
|
||
exec sp_trace_setevent @TraceID, 12, 64, @on
|
||
exec sp_trace_setevent @TraceID, 12, 66, @on
|
||
|
||
|
||
-- Set the Filters
|
||
declare @intfilter int
|
||
declare @bigintfilter bigint
|
||
|
||
exec sp_trace_setfilter @TraceID, 10, 0, 7, N'Générateur de profils SQL Server - e1a6e01a-ba6d-4d07-8192-63ac2b36e2d9'
|
||
set @bigintfilter = 100000
|
||
exec sp_trace_setfilter @TraceID, 13, 0, 4, @bigintfilter
|
||
|
||
-- Set the trace status to start
|
||
exec sp_trace_setstatus @TraceID, 1
|
||
|
||
-- display trace id for future references
|
||
select TraceID=@TraceID
|
||
goto finish
|
||
|
||
error:
|
||
select ErrorCode=@rc
|
||
|
||
/*
|
||
pour fermer la trace :
|
||
exec sp_trace_setstatus @TraceID, 0 --> arrête
|
||
exec sp_trace_setstatus @TraceID, 2 --> libérer la mémoirearrête
|
||
-- récupérer le fichier sous forme tabulair
|
||
SELECT *
|
||
FROM sys.fn_trace_gettable('premier fichier', nb_fichier)
|
||
*/
|
||
|
||
|
||
finish:
|
||
go
|