Finding Query text thru Extent Events features?

• SQL Galaxy

  One Orange Chip

  Points: 29472

  More actions

  September 30, 2014 at 12:50 am

  #311898

  Hi,

  Event messages appeared in Error log file on Yesterday at 5:12 PM, so I want to find out the particular query text and SPs name which was caused problem on that time.

  Error Messages:

  Error: 8645, Severity: 17, State: 1.

  A timeout occurred while waiting for memory resources to execute the query in resource pool 'default' (2). Rerun the query.

  Is it possible to capture thru Extent event in that query at 5: 12 PM on yesterday?

  Thanks

  ananda