Hello everyone. We're having a sporadic problem with our web application.
We have a test server set up with sql 2000 and iis 5 on 2000 server running
our web app. After doing some things in the application (it doesn't seem to
matter which things) any link that runs a query will be really slow (8-15
seconds). When I look at the queries through profiler it appears that what
is slowing me down is the disconnection of sql connections. For instance in
the profiler I will have: audit logout 10000ms. Has anyone seen this
behavior before? Any ideas?
PS - I saw the KB article about problems when connecting with ip -- we are
connecting with the host name.