remote query timeout

remote query timeout / 設在client 端

Scenario 1 – long query hit timeout error

  • [on SQL_A ] : configure linked server to SQL_B
  • [on SQL_A ] : change “remote query timeout” to 1 sec
  • [on SQL_A ] : issue long query to select data from SQL_B

 

Scenario 2 – extend “remote query timeout” setting to allow long query

  • [on SQL_A ] : configure linked server to SQL_B
  • [on SQL_A ] : change “remote query timeout” to 900 sec
  • [on SQL_A ] : issue long query to select data from SQL_B