如何删除SQL事件探查器跟踪中的审核注销？ [英] How to remove audit logout in trace of SQL Profiler?

问题描述

嗨朋友们，



我正在分析一段性能不佳的代码。该代码用于发送邮件。发送5封邮件大约需要10分钟，附件大小约为2MB。



当我使用SQL Profiler分析这段代码时，在跟踪文件中我发现审核注销事件在跟踪中不断重复。审核注销事件大部分时间都在跟踪中。



我搜索了解决方案，每个人都解释了什么是审核注销，但我找不到如何在跟踪中删除此事件的解决方案，以便我的代码的性能可以改善了很多。请帮帮我。



TIA。

Hi Friends,

I am analyzing a piece of code for poor performance. The code is used to send a mail. It takes around 10 min to send 5 mails along with an attachment of approximately size 2MB.

When I analyzed this piece of code using SQL Profiler, in the trace file I find that Audit log out event keeps repeating in the trace. The Audit logout event is taking most of the time in the trace.

I searched for the solution,everyone explains what is Audit logout but nowhere I found a solution on how to remove this event in the trace so that performance of my code can improve a lot. Please help me.

TIA.

推荐答案

< br $> b $ b

检查这个...



SQL Server Profiler Step by Step [ ^ ]



希望这对您有所帮助。





干杯

Hi,


Check this...

SQL Server Profiler Step by Step[^]

Hope this will help you.


Cheers

打开新的性能分析时，请参阅事件选择选项卡并单击它，在此处取消选中安全审核下的审核登录和审核注销，然后单击运行开始。



只是在备注上，不查看分析器中的事件不会使它们不会发生或花费更少的时间，以便它只会影响显示的结果，隐藏该信息。

when opening a new profiling see the Events Selection tab and click it, here uncheck Audit Login and Audit Logout under Security Audit, next click run to begin.

Just on a note, not viewing the events in the profiler will not make them not happen or take any less time so whatever it will only affect the results displayed, to hide that information.

这篇关于如何删除SQL事件探查器跟踪中的审核注销？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！