开发者

SQL Profiler Template File Format

开发者 https://www.devze.com 2023-01-14 22:35 出处:网络
Does anyone have information on the file format used to hold SQL Profiler Templates (NOT Profiler trace files)? Or a way to create or parse these via C#?

Does anyone have information on the file format used to hold SQL Profiler Templates (NOT Profiler trace files)? Or a way to create or parse these via C#?

Thanks very 开发者_开发问答much.


No, but you can programmatically create and run traces w/ the sp_trace% family of stored procedures, if that helps at all.

The process goes something like sp_trace_create -> sp_trace_setevent, sp_trace_setfilter -> sp_trace_setstatus

You might also investigate extended events. The learning curve is a little steep, but they allow for more fine-grained data collection than a SQL trace, for some event types at least.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号