[SQL Server] Slow connection establishment

[egrath]

Hi,

i have a serious performance problem with one of our Database Servers, which is currently running SQL Server 2000.

Using the "Mimer ODBC Trace DLL" i discovered that the call to SQLConnectW ODBC Function call takes about 3 seconds on this machine - which probably causes this performance bottleneck. On other Machines, configured in the same way the same Call (tested with the same application) takes about 0.0150 seconds.

Do you have any ideas whats going wrong here?

Thanks and Bye, Egon

[egrath]

I've found the problem.

Don't know why, but after disabling the installed CA Unicenter Agents the connection estabilshment takes only 0.0140 seconds instead of the previous 2.78 ....

Egon