June 13, 2013 at 8:45 pm
Comments posted to this topic are about the item Capture current queries when cpu is above certain threshold
June 28, 2013 at 4:18 pm
Msg 111, Level 15, State 1, Procedure p_capture_high_cpu_queries, Line 20
'CREATE/ALTER PROCEDURE' must be the first statement in a query batch.
June 28, 2013 at 4:24 pm
not sure which version of sql server you are running, but if you get that error
please try to run the script in 2 steps.
creating the table as step one
and once the table is created run the part where it creates the stored procedure.
June 28, 2013 at 4:25 pm
Yep, that did the trick. Thanks.
May 6, 2015 at 9:42 am
Thanks for the script. I'll give it a try.
May 19, 2015 at 6:43 pm
Is there anyway to test this?? I mean that how can I make sure that the table is getting populated whenever this situation happens. Just need a test case of this. Please assist.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply