SQL Server audit logout creates huge number of reads

sql sql-server sql-server-2008 database-tuning sql-tuning
AutoCiudad picture AutoCiudad · Oct 24, 2012 · Viewed 21.8k times · Source

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.

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

Answer

user806549 picture user806549 · Oct 24, 2012

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:

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.

Related questions

How can I get column names from a table in SQL Server?

I want to query the name of all columns of a table. I found how to do this in: Oracle MySQL PostgreSQL But I also need to know: how can this be done in Microsoft SQL Server (2008 in my case)?

Read More
How to Delete using INNER JOIN with SQL Server?

I want to delete using INNER JOIN in SQL Server 2008. But I get this error: Msg 156, Level 15, State 1, Line 15 Incorrect syntax near the keyword 'INNER'. My code: DELETE FROM WorkRecord2 INNER JOIN Employee ON EmployeeRun=EmployeeNo WHERE Company = '1' …

Read More
Rename column SQL Server 2008

I am using SQL Server 2008 and Navicat. I need to rename a column in a table using SQL. ALTER TABLE table_name RENAME COLUMN old_name to new_name; This statement doesn't work.

Read More