Post reply

Audit Logout

  • September 3, 2002 at 10:03 pm

    #105135

    Hi,

    I have been trying to monitor the CPU usage of my SQLserver.I turned on Profiler and realized that there is an event call "Audit Logout" which takes up alot of the CPU usage.

    Anyone know why??

  • September 12, 2002 at 6:49 pm

    #436453

    Check from Enterprise Man. in the properties of the server, in the Security Tab the Audit Level. If you had checked any other than None, the server is auditing the logon process that consume resources.

  • September 12, 2002 at 8:34 pm

    #436459

    IS it normal for logout process to take up so much system resources?

  • September 13, 2002 at 4:30 am

    #436468

    I would say yes, I don't normlly look at CPU usage in regards to those items as I believe they may be incorrect but not sure. I see anywhere from 0 to 30000 with and does not see to relate to loads. Have no details on why it looks this way.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • September 13, 2002 at 7:52 am

    #436486

    Consider what occurs during a logout process:

    - SQL Server takes care of all pending transactions (or at least checks to see if there are any).

    - SQL Server goes the process to close down their SPID. This includes memory deallocation (goes back to memory pool)

    - OS has to tear down TCP session.

    All this together happens in a really short time. So it wouldn't be unusual to see processors spiking during a logout.

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

    K. Brian Kelley
    @kbriankelley

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply