Posted by Oscar Santiesteban Jr. on 11/19/56 11:37

I need help...here is the problem.

Last weekend, the servers in our datacenter where moved around. After this
move, and maybe coincidental, 1 server is performing very poor. After
running a trace with SQL Profiler, I saw the problem which was later
confirmed with another tool for SQL server performance monitoring. It seems
that all connections to the SQL server (between 200 - 400) are doing a login
/ logout for each command that they process. For example, the user's
connection will login, perform a SELECT, and then logout. This is not a
..NET application. The client software was not changed, it is still the
same. The vendor has said that it is not supposed to do that, it is
supposed to use 1 connection that log's on in the morning and logs off at
the end of the day or whenever the user exits. 1 user may have several
connections to the database.

At times, the server is processing over 250 login / logouts (avgeraged for
30 second period). Has anyone seen this problem? I have the server in
AUDIT FAILUREs only. The server has become very unresponsive, things that
took 3 seconds now take over 15 seconds.

Any ideas???

[Back to original message]