Monitor alerts showing "CREATE" statements?

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

Monitor alerts showing "CREATE" statements?

Postby sgilboy » Thu Apr 25, 2013 7:42 pm

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?

Image
sgilboy
 
Posts: 30
Joined: Wed Jun 22, 2011 7:38 pm

Postby sgilboy » Thu Apr 25, 2013 9:21 pm

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
 
Posts: 30
Joined: Wed Jun 22, 2011 7:38 pm


Return to SQL Monitor 3

Who is online

Users browsing this forum: No registered users and 0 guests

cron