Capture current queries when cpu is above certain threshold

• unaur

  SSC Veteran

  Points: 200

  More actions

  June 13, 2013 at 8:45 pm

  #275044

  Comments posted to this topic are about the item Capture current queries when cpu is above certain threshold

• mary scheffler

  Grasshopper

  Points: 21

  More actions

  June 28, 2013 at 4:18 pm

  #1628440

  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.

• unaur

  SSC Veteran

  Points: 200

  More actions

  June 28, 2013 at 4:24 pm

  #1628442

  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.

• mary scheffler

  Grasshopper

  Points: 21

  More actions

  June 28, 2013 at 4:25 pm

  #1628443

  Yep, that did the trick. Thanks.

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  May 6, 2015 at 9:42 am

  #1795988

  Thanks for the script. I'll give it a try.

• abhinav.c.singh

  SSC Journeyman

  Points: 96

  More actions

  May 19, 2015 at 6:43 pm

  #1799208

  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.