November 25, 2009 at 1:40 pm
Folks
i was hearing timeout errors issues suddebly since one week ,but i did not find any errors in sql log
these time out are kind of irregular interals they start in different timings in the night.
Not to sure how to catch them and pin point the problem
please put me in right drrection.
November 25, 2009 at 9:57 pm
shree (11/25/2009)
Folksi was hearing timeout errors issues suddebly since one week ,but i did not find any errors in sql log
these time out are kind of irregular interals they start in different timings in the night.
Not to sure how to catch them and pin point the problem
please put me in right drrection.
what kind of timeout errors?
Did you hear it from users? or from developers?
In either case 9 out of 10 times it's the web or app server that is of course if you DB has a high change rate and your indexes are not rebuild on weekly/daily basis then we could agree that it's the DB.
November 25, 2009 at 10:17 pm
The issue could be connected to many areas:
1. Network error.
2. Application times out in less time (someone has changed the configuration value)
3. Execution plans have changed.
4. New functionality /query is added
5. Data is fragmented
You may have to eliminate one by one to find the cause.
Cheers,
Prithiviraj Kulasingham
http://preethiviraj.blogspot.com/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply