除了探查器之外的SQL Storedprocedure跟踪(SQL Storedprocedure trace other than profiler)

除了探查器之外的SQL Storedprocedure跟踪(SQL Storedprocedure trace other than profiler)

要捕获生产环境中正在运行的存储过程的内容，将使用分析器。 是否会放慢环境？ 是否会影响性能？ 如果是这样，在不影响性能的情况下跟踪SP命中的替代方法是什么？

To capture what are the Stored procedures are being hit in Production environment the profiler would be used. Whether it would be slowdown the environment? Whether it will affect the performance? If so, what are the alternative to trace the SP hits without affecting the performance?

最满意答案

您可以通过存储过程直接在服务器上创建跟踪，而不是使用分析器工具

介绍SQL跟踪

从历史上看，这种跟踪比使用分析器消耗的资源更少 - 当然，所有跟踪都必须消耗一些资源。

Rather than using the profiler tool, you can create traces directly on the server via stored procedures

Introducing SQL Trace

Historically, such tracing consumed fewer resources than using profiler - although, of course, all tracing must consume some resource.