Re: Randomly get timeout on SqlClient hitting localhost

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Okay, the timeouts can occur on any system. There are (generally) two types
of timeouts that occur : Connection timeouts and Command timeouts. The
former can be caused by a connection pool issue or by the server (or system)
being too busy to process the query. The latter can be caused by a lock
conflict or (again) the server being too busy to complete the operation in
time. Just because it's a client system does not mean that there aren't
other competing applications fighting for CPU time--like Age Of Empires. ;)

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"Steven Cheng[MSFT]" <stcheng@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:41lr$RwwHHA.4484@xxxxxxxxxxxxxxxxxxxxxxxxx
Thanks for your reply Dave,

Since it is a client form application, I think the problem should not be
caused by performance stress. If possible, you can try connecting to
different database to see whether you'll encounter the same error.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead


This posting is provided "AS IS" with no warranties, and confers no
rights.



.

Relevant Pages

  • Re: timout error on server running vb .net routine
    ... > There are two timeouts in SQL Server that you want to think about. ... > Connection Timeouts and Command Timeouts. ... > thing that causes Command Timeouts, there are tons of things it could be. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: timout error on server running vb .net routine
    ... There are two timeouts in SQL Server that you want to think about. ... Connection Timeouts and Command Timeouts. ... thing that causes Command Timeouts, there are tons of things it could be. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Randomly get timeout on SqlClient hitting localhost
    ... of timeouts that occur: Connection timeouts and Command timeouts. ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: db2/php random error
    ... > Look at any setting the deal with connection timeouts. ... > section for odbc connections in php.ini, and possibly one in the ODBC ... affect db2/odbc, I am loathe to change it. ...
    (comp.lang.php)
  • Connection timeout to Windows XP Remote Desktop
    ... When we connect to Remote Desktop on Windows XP SP1 and SP2 we sometimes get ... timeouts during the login procedure. ... after which the connection is terminated. ... for instance the amount of memory used by the loggedon user is determining ...
    (microsoft.public.windowsxp.work_remotely)