DBA's quick guide to timeouts!
March 11, 2003[From vyaskn.tripod.com/]
Chris Kempster discusses the various types of timeout problems, and shows you how to alter various settings to address timeout errors. He also provides VB code samples along with this article.
The application development DBA needs a good understanding of the overarching application architecture and subsequent technologies (COM+, MSMQ, IIS, ASP etc) to more proactively debug and track down database performance problems. A good place to start is common timeout error. This article will provide a brief overview of where to look and how to set the values.
The article continues at http://vyaskn.tripod.com/watch_your_timeouts.htm