Posted by Jack Vamvas on 09/30/36 11:37

What connection type is used , is it ODBC or DSN Less?
Also, which version of SQL server are you using?




--
Jack Vamvas
__________________________________________________________________
Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
New article by Jack Vamvas - SQL and Markov Chains -
www.ciquery.com/articles/art_04.asp
"Oscar Santiesteban Jr." <o_santiesteban@bellsouth.net> wrote in message
news:xmgzf.6634$Ea3.1451@bignews2.bellsouth.net...
> 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]