Timeout Expired Error occurred while executing a SQL query

  • I have received the following error while executing a query in SQL Server

    Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding

    I encounter an issue where executing the same query at different times of the day produces varying results. Sometimes, I receive a timeout error despite having set the timeout setting to one hour. Typically, the query takes around 15 minutes to execute, but I often encounter the timeout error after just 5 minutes of execution. What could be causing this issue, and what possible solutions can I explore?

     

  • This was removed by the editor as SPAM

  • There are different levels of timeouts

    Connection timeout

    Command timeout

    Remote query timeout

    Can you provide some background?

  • IT researcher wrote:

    Typically, the query takes around 15 minutes to execute

      Why?

    What reseach have you done?

    What methodology did you use?

Viewing 4 posts - 1 through 3 (of 3 total)

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