Timeout Expired Error occurred while executing a SQL query

• IT researcher

  SSCertifiable

  Points: 7616

  More actions

  October 23, 2024 at 7:06 am

  #4472566

  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?

   

• October 23, 2024 at 7:13 am

  This was removed by the editor as SPAM

• Jo Pattyn

  SSC-Dedicated

  Points: 32394

  More actions

  October 23, 2024 at 10:26 am

  #4472655

  There are different levels of timeouts

  Connection timeout

  Command timeout

  Remote query timeout

  Can you provide some background?

• Ken McKelvey

  SSCoach

  Points: 18890

  More actions

  October 23, 2024 at 10:36 am

  #4472665

  IT researcher wrote:

  Typically, the query takes around 15 minutes to execute

    Why?

  What reseach have you done?

  What methodology did you use?