I recently worked on an issue where a SQL job was throwing a 'Query Timeout' error, even though the linked server was working properly.
Curious to know, how did you concluded particular stored procedure was running for 15 min ?
Is there any way to capture the run duration of the particular stored procedure?
Curious to know, how did you concluded particular stored procedure was running for 15 min ?
Is there any way to capture the run duration of the particular stored procedure?