SQL Management Studio > SQL Server Profiler > New Trace
This helps catch timeouts of SQL queries.  Enables one to look at duration value of the SQL Batch command or Stored Procedure command.
Usually SQL Timeouts do not raise any SQL Errors at all, but, you can included SQL Error and User Error Message rows to make sure no other exception happens during execution of the original SQL statement.  
To filter only WA calls, set Application Filter = MAS 500 W%