Competition: What’s your favorite Redgate tool? Enter now.

Monitor alerts showing "CREATE" statements?

sgilboysgilboy Posts: 41
edited April 25, 2013 4:21PM in SQL Monitor Previous Versions
This one has my head scratching... I've been getting lit up by Monitor alerts with "long running query" but the "SQL Process Fragment" is a CREATE PROCEDURE execution, this totally is not correct..... i'd assume that the PROC actually getting run is the problem (maybe index related, that's why it's taking so long), but Monitor is being useless in helping me figure this out:

Any ideas on how to extract some data I could actually use to help me fix this issue?

27yopyb.jpg

Comments

  • turning Tracing on, grabbing the SPID from the alert, and then going to the Trace log under "SQL Processes" help me find the actual EXEC statement...

    /closed
Sign In or Register to comment.