September 8, 2014 at 11:22 am
Some time back I created an alert ... that is suddenly capturing about 3 failures per day on one of our servers... is there any way to get the alert to send out something useful like a plan handle?
DATE/TIME:9/8/2014 1:19:05 PM
DESCRIPTION:The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query. If you believe you have received this message in error, contact Customer Support Services for more information.
COMMENT:(None)
September 17, 2014 at 7:22 pm
Have you considered using a trigger?
September 17, 2014 at 8:14 pm
Alerts for severity of 10-16 are not capable of having it log more information.
Your option would be to use Extended Event session or Profiler. I believe Extended Event would be easier to capture the specific transactions hitting that severity though. I believe this article will help show you how to create the session, just may change the predicate to 016.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply