ALM instance CPU spike

Question ID: 108531
0
0

One of our ALM instances has a recent cpu and memory spike we noticed that the following query is running:

(@P1 varchar(8000),@P2 varchar(8000),@P3 varchar(8000),@P4 datetime)SELECT TOP 1 CLCTSK_ID,CLCTSK_PROJECT_UID FROM (SELECT TOP 1 CLCTSK_ID,CLCTSK_PROJECT_UID FROM CALCULATION_TASKS WHERE (((CLCTSK_ENGINE_NAME = @P1 ) OR (CLCTSK_ENGINE_NAME = @P2 ) OR (CLCTSK_ENGINE_NAME = @P3 )) AND (NOT CLCTSK_ACTUAL_START_TIME IS NULL ) AND (CLCTSK_ACTUAL_START_TIME < @P4 ) AND (((CLCTSK_ID NOT IN (74101,74102,74130,74131,74103,74104,74105,74106,74107,74108,74109,74110,74111,74112,74113,74114,74115,74116,74117,74118,74119,74120,74121,74122,74132,74133,74134,74135,74136,74137,74138,74139,74123,74124,74140,74141,74142,74143,74144,74145,74146,74147,74148,74149,74125,74126,74127,74150,74151,74152,74153,74154,74155,74156,74157,74158,74159,74160,74161,74128,74129,74162,74163,74164,74165,74166,74167,74168,74169,74170,74171,74172,74173,74174,74175,74176,74177,74178,74179,74184,74180,74181,74182,74183,74185,74186,74187,74188,74189,74190,74191,74192,74193,74194,74195,74196,74197,74203,74204,74198,74199,74200,74201,74202,74205,74206,74207,74209,74210,74208,74211,74212,74213,74214,74215,74216,74218,74217,74219,74220,74221,74222,74251,74250,74249,74248,74223,74224,74226,74225,74227,74228,74229,74230,74231,74232,74233,74235,74234,74236,74237,74252,74253,74254,74255,74256,74257,74258,74259,74260,74261,74262,74263,74264,74265,74238,74239,74266,74267,74268,74269,74270,74271,74277,74275,74272,74273,74274,74240,74276,74278,74279,74281,74280,74282,74283,.... What is causing this query to run and what can we do to stop it?

Marked as spam
Posted by (Questions: 91, Answers: 0)
Asked on July 26, 2018 2:59 pm
5 views
Answers (1)
0
Private answer

More than likely what you were seeing are calculations being run on the project planning and tracking so it is not really anything to worry about, I would just keep an eye on it, if you are not using that feature you can deactivate project planning and tracking from site admin.

Marked as spam
Posted by (Questions: 0, Answers: 340)
Answered on July 26, 2018 3:00 pm