title: Query runs for hours
body: <p>Some of the queries that execute overnight run for exactly 5 hours before logging a failure message. These queries retrieve records from a linked server which is also a SQL server. When I run the same query in the morning it executes in a minute. The timeout property in both servers is set to 1 hour. So I'm trying to understand how it can execute for more than an hour and how it can stop after 5 hours every time. Please help me understand what I'm missing.</p>
  
  <p>Thanks.</p>