SQL Server审核注销会创建大量读取 [英] SQL Server audit logout creates huge number of reads

问题描述

我正在使用SQL Server Profiler找出正在消耗SQL进程的进程，并且我发现事件类Audit Logout导致大量读取和消耗cpu进程.

I'm using SQL Server Profiler to figure out what process are consuming SQL process and I found that the event class Audit Logout is causing a huge number of reads and consume cpu process.

正常吗?还是我在SQL Server配置中有问题?

Is it normal? Or do I have something wrong in the SQL Server configuration?

推荐答案

从退出连接开始，审核注销事件会汇总许多其值，例如读/写，连接时间等.

The audit logout event aggregates a lot of its values like reads/writes, connection times, etc. from the time the connection was opened.

请参见 http://msdn.microsoft.com/en-us/library/ms175827.aspx -您在此处添加的针对特定问题的定义:

See http://msdn.microsoft.com/en-us/library/ms175827.aspx - the definition for your specific question added here:

Reads Number 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.

这篇关于SQL Server审核注销会创建大量读取的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！