How to find out Stored procedures, function and triggers which are timing out?

Question

question

santoshvicky asked Jul 12, '13

How to find out Stored procedures, function and triggers which are timing out?

I want to find in my production which are the Stored procedures, functions or triggers are getting timed out?

stored-procedures functions timeout-expired

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey ♦♦ commented · Jul 16, 2013 at 09:19 AM

Please indicate helpful answers by clicking on the thumbs up next to those answers. If any one answer lead to a solution, show that by clicking on the thumbs up next to that answer.

1 ·

Answer 1 · 2013-07-12T14:21:59Z

ankushparab answered Jul 12, '13

In brief... Using profiler trace or extended events. Basically put filter on duration based on your timeout value.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2013-07-13T10:56:07Z

Grant Fritchey answered Jul 13, '13

I would suggest using extended events if you are on SQL Server 2008 or greater. The reason is, filtering in extended events is better than using a trace. A trace will capture the full event, including all the columns you specify, then filter based on your criteria. Extended events will filter events captured based on your criteria before they collect all data. It's one of the many things that makes extended events better. [Here's a link][1] to get you started with extended events. [1]: http://msdn.microsoft.com/en-us/library/dd822788(v=SQL.100).aspx

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question