Re: Randomly get timeout on SqlClient hitting localhost
- From: David Thielen <thielen@xxxxxxxxxxxxx>
- Date: Tue, 10 Jul 2007 10:56:01 -0700
I think (going on memory here) that it only happens when I am running under
the debugger. Could that cause some kind of lockout?
It happens fast. It's not that a couple of seconds goes by and then it
returns this error - it's in under a second. So I don't think it's a true
timeout.
Age of Empires - love that game. Haven't played in awhile though. Enemy
Nations rocks too.
--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htm
"William (Bill) Vaughn" wrote:
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.
- Follow-Ups:
- Re: Randomly get timeout on SqlClient hitting localhost
- From: William \(Bill\) Vaughn
- Re: Randomly get timeout on SqlClient hitting localhost
- References:
- RE: Randomly get timeout on SqlClient hitting localhost
- From: Steven Cheng[MSFT]
- RE: Randomly get timeout on SqlClient hitting localhost
- From: Steven Cheng[MSFT]
- Re: Randomly get timeout on SqlClient hitting localhost
- From: William \(Bill\) Vaughn
- RE: Randomly get timeout on SqlClient hitting localhost
- Prev by Date: How may I use the IN operator when using a RowFilter on a DataView?
- Next by Date: Re: Writing to Excel File via OleDB
- Previous by thread: Re: Randomly get timeout on SqlClient hitting localhost
- Next by thread: Re: Randomly get timeout on SqlClient hitting localhost
- Index(es):
Relevant Pages
|
