怎样运用SQL代理来进行一次SQL探查器跟踪呢.docx

怎样运用SQL代理来进行一次SQL探查器跟踪呢
SQL 探查器跟踪运用系统存储过程来建立。你可以从一个现有的探查器跟踪中运用S set ***@Folder = ***@Folder + '\'　　-- Check if Folder exists　　set ***@cmd = 'dir ' +***@Folder　　exec ***@rc = master..xp_cmdshell ***@cmd,no_output　　if (***@rc != 0) begin set ***@msg = 'The specified folder ' + ***@Folder + '　　does not exist, Please specify an existing drive:\folder '+ cast(***@rc as　　varchar(10)) raiserror(***@msg,10,1) return(-1)　　end　　--Create new trace file folder　　set ***@cmd = 'mkdir ' +***@Folder+***@StartDatetime　　exec ***@rc = master..xp_cmdshell ***@cmd,no_output　　if (***@rc != 0) begin set ***@msg = 'Error creating trace folder : ' +　　cast(***@rc as varchar(10)) set ***@msg = ***@msg + 'SQL Server 2005 or later　　instance require OLE Automation to been enabled' raiserror(***@msg,10,1)　　return(-1)　　end　　set ***@TraceFile = ***@Folder+***@StartDatetime+'\trace'　　exec ***@rc = sp_trace_create ***@TraceID output, 2, ***@TraceFile,　　***@MaxFileSize, ***@StopTime　　if (***@rc != 0) begin set ***@msg = 'Error creating trace : ' + cast(***@rc as　　varchar(10)) raiserror(***@msg,10,1) return(-1)　　end　--> Using your saved trace file, add the '-- Set the events' section below Using your saved trace file, add the '-- Set the Filters' section below Customization is now completed <--　　-----------------------------------------------　　-- This filter is added to exclude all profiler traces.　　exec sp_trace_setfilter ***@TraceID, 10, 0, 7, N'SQL Profile