Comments posted to this topic are about the item Capture current queries when cpu is above certain threshold
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.
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.
Yep, that did the trick. Thanks.
Thanks for the script. I'll give it a try.
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 5 (of 5 total)