You are here: Re: Timeout errors « MsSQL Server « IT news, forums, messages
Re: Timeout errors

Posted by Erland Sommarskog on 05/20/06 18:48

pb648174 (google@webpaul.net) writes:
> My theory all along is that the network connectivity between the
> machine making the connection and the database server is somehow
> intermittently going up and down. If that is the case, what would be
> the best way to confirm? Is the amount of time (15 seconds) consistent
> with this?

15 is the default connection timeout. Normally a connection timeout
results in a different message. But maybe this message could appear if
the connection initially beings to start up, but then fails to complete
for some reason. But that is just pure speculation on my part.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация