Profiler Audit Logout Performance

  • Thread starter Brian Wotherspoon
  • Start date

B

Brian Wotherspoon

Hi All,

I'm running an online transaction processing system using an SQL Server
2000 SP3 database server and an online application server.

I seem to be hitting some performace issues I believe be related to
connections. Certainly I've tracked it to a single point in the
processing.

Running a profiler trace indicates that the stored procedure and SQL
statements within have no performance issues, indexes are all fine
according to the execution plan.

However the Audit Logout line that appears after each call to the
procedure has a duration of several hundred ms, even though the
procedure executes in a max of 16ms.

Does this indicate that performance is being hit by the overhead of
creating and destroying connections? I understood that connection
pooling, which is enabled as far as I can tell, was supposed to prevent
these kind of problems.

Any help is very much appreciated.

Brian.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top