Second connection to SQL Server 2008 slow

Discussions specific to Team Developer 5.1.

Second connection to SQL Server 2008 slow

Postby Andre Sperling » Sun Mar 20, 2011 11:17 pm

Hello,

I using a "SQL Server 2008" runing on a "Windows Server 2008 Standard" operating system.

If I connect the first time to the SQL-Server with SQL-Talk using a ODBC-Connection the connection is fast. Also the following SELECT statements are fast. But if I made a disconnect and after that a connect. Then the connection is more then 10 time slower. The only what helps is to close SQLTalk and start again.

If i using a other Machine to connect to this Server, i do not have this problems.
I have also the same configuration on a other Plant, there I also do not have this Problems. So i believe that there is a Problem in the Windows setup on this particular computer. Because all other Setting are the same in compare to the other Plant (ODBC-Driver, ODBC-Settings, SQL.INI settings, Unify drivers).
I do not believe there is a Problem with the SQL-Sever, because other computer can connect without Problems. All computer use the same login to the SQL-Server.

Does anybody have an idea, where the problem is?
(you can answer in german or english)

Thanks and best regards

Andre
Andre Sperling
 
Posts: 1
Joined: Thu Mar 17, 2011 2:18 am

Return to Team Developer 5.1

Who is online

Users browsing this forum: No registered users and 2 guests