Connectiontime out error

  • shree

    Say Hey Kid

    Points: 702

    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.

  • AlexSQLForums

    SSChampion

    Points: 14254

    shree (11/25/2009)


    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.

    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.

    Alex S
  • G.R.Prithiviraj Kulasingham

    SSCarpal Tunnel

    Points: 4104

    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 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply