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
 General SQL Server Forums
 New to SQL Server Administration
 system timeout error

Author  Topic 

badara24
Starting Member

3 Posts

Posted - 2010-03-11 : 07:16:00
Hai

in my organsation we are using sql server 2000 and it is in cluster.
we have different applications accesing this database through intranet and internet.the problem is we are getting system timeout error in the application.when any request to database.

Thanks and regards
badara

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-03-11 : 15:29:06
Here's a recent blog of mine that discusses application timeouts: http://weblogs.sqlteam.com/tarad/archive/2010/03/08/Troubleshooting-Application-Timeouts-in-SQL-Server.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

badara24
Starting Member

3 Posts

Posted - 2010-03-11 : 23:01:38
Hai

Thanks for the reply,regarding to the timeout error,I with developer team vb.net,increase the time 2min from dafault time of 30second in the code of the application for the query to execute.and in the database we removed the Translogfiles of the databases we are getting timeout error and cleared some clocks.but still we are getting same problem,as my database is very imp for the revenue and hr modules.And iam new to this sql2000 adminstration.Can u People explain in little easier way so that i can work on this issue.Kindly

Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-03-11 : 23:25:31
What does "we removed the Translogfiles" mean? That sounds very bad.

You need to check what queries are performing bad and see if they can be improved by rewriting them or adding indexes.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page
   

- Advertisement -