How can we help you today? How can we help you today?

Monitor alerts showing "CREATE" statements?

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
sgilboy
0

Comments

1 comment

Sort by
  • sgilboy
    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
    sgilboy
    0

Add comment

Please sign in to leave a comment.