Time out Errors

• ramana3327

  SSCoach

  Points: 19722

  More actions

  April 13, 2014 at 7:23 pm

  #284481

  Hi,

  I want to find out the time out errors for a particular SP. Please let me know how to check that?

  Thanks,

  Ramana

• Shawn Melton

  SSC-Insane

  Points: 24685

  More actions

  April 13, 2014 at 7:38 pm

  #1705621

  You can go through this video on finding query timeouts from MidnightDBAs.

  You basically use Profiler or server-side trace to track the T-SQL starting and ending events. The statements that have a starting event and no ending event are prime candidates for problems.

  Shawn Melton
  Twitter: @wsmelton
  Blog: wsmelton.github.com
  Github: wsmelton

• ramana3327

  SSCoach

  Points: 19722

  More actions

  April 13, 2014 at 9:35 pm

  #1705624

  Thanks Shawn