SQL Server 审核注销会产生大量读取
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/13049452/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
SQL Server audit logout creates huge number of reads
提问by AutoCiudad
I'm using SQL Server Profiler to figure out what process are consuming SQL process and I found that the event class Audit Logoutis causing a huge number of reads and consume cpu process.
我正在使用 SQL Server Profiler 找出正在消耗 SQL 进程的进程，我发现事件类Audit Logout导致大量读取并消耗 cpu 进程。
Is it normal? Or do I have something wrong in the SQL Server configuration?
正常吗？还是我的 SQL Server 配置有问题？
回答by
The audit logout event aggregates a lot of its values like reads/writes, connection times, etc. from the time the connection was opened.
审计注销事件聚合了许多值，例如从打开连接开始的读/写、连接时间等。
See http://msdn.microsoft.com/en-us/library/ms175827.aspx- the definition for your specific question added here:
请参阅http://msdn.microsoft.com/en-us/library/ms175827.aspx- 您在此处添加的特定问题的定义：
ReadsNumber of logical read I/Os issued by the user during the connection.
ReadsNumber of logical read I/Os issued by the user during the connection.
So basically, the number you are seeing is not for the audit event itself, it is for all actions done by the connection that is logging out.
所以基本上，您看到的数字不是针对审核事件本身，而是针对正在注销的连接执行的所有操作。
