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 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy