Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Track users for Time out problem

Author  Topic 

CanadaDBA

583 Posts

Posted - 2005-04-04 : 11:24:16
Some of users had ODBC time out problem this morning and I hear the problem still exists. How can I check the users if I don't want to use Profiler? How can I find out why they get time out? There is restriction for me to run scripts or Profiler against the production.

Canada DBA

jason
Posting Yak Master

164 Posts

Posted - 2005-04-04 : 14:43:14
ODBC has timeout settings of its own. You could increase the timeout values.

There's a lot to consider with timeouts.

Have there been any schema changes to the database?

Is the server overloaded?

Are the users experiencing the problem all on the same LAN segment?
Go to Top of Page
   

- Advertisement -