simple query cannot be killed

• y.loewidt

  SSC Rookie

  Points: 37

  More actions

  December 8, 2010 at 3:16 am

  #388392

  Hi Guys,

  For some reason the following query takes 100% CPU of one Core. I cannot kill it.. any one has a clue why ?

  SELECT

  CASE WHEN '1' IN(SELECT '1') THEN '1 IN 1' ELSE '1 NOT IN 1' END,

  CASE WHEN '1' IN(SELECT NULL) THEN '1 IN NULL' ELSE '1 NOT IN NULL' END

• y.loewidt

  SSC Rookie

  Points: 37

  More actions

  December 8, 2010 at 3:35 am

  #1259984

  put the SPID in the following code to see if it takes 100% of one of your cores, and please post your results

  declare @Time datetime2(7)

  declare @CPU66 bigint

  declare @SPID int

  set @SPID=

  select @CPU66 = max(case when spid=@SPID then cpu end),

  @Time=cast(CURRENT_TIMESTAMP as datetime2(7)) from master..sysprocesses where spid = @SPID

  waitfor delay '00:01:00.000'

  select

  (max(case when spid=@SPIDthen cpu end)-@CPU66+0.0)/(datediff(millisecond,@Time,cast(CURRENT_TIMESTAMP as datetime2(7)))+0.0) as SPID66 from master..sysprocesses where spid = @SPID