[Briscard]

Добрый день!
У нас в логах сервера несколько дней назад появилось предупреждение, которое повторяется в среднем шесть раз в минуту. Может, кто-то подскажет: что это может быть, чем грозит и как бороться?

Query execution time of 30.1 seconds exceeded the threshold of 10 seconds. Thread: 12; Database: I_Free_MSCRM; Query:
WITH Candidates
(
ActivityId
) AS
(SELECT ActivityId
FROM EmailHashBase WITH (NOLOCK)
WHERE ActivityId IN
(SELECT ActivityId
FROM EmailHashBase WITH (NOLOCK)
WHERE HashType = 0
AND Hash IN (-1037874640,1231474368,1001172473,-1420793558)
GROUP BY ActivityId
HAVING COUNT(ActivityId) >= 4
)
AND HashType = 1
AND Hash IN (1236587759,-1246206773)
GROUP BY ActivityId
HAVING COUNT(ActivityId) >= 2
)
SELECT TOP 1 a.ActivityId
FROM ActivityPointerBase AS a WITH (NOLOCK)
WHERE a.ActivityId IN
(SELECT ActivityId
FROM Candidates AS c
WHERE(
(SELECT COUNT(*)
FROM EmailHashBase AS h
WHERE h.ActivityId = c.ActivityId
AND h.HashType = 0
)
<= 4
)
)
ORDER BY a.ModifiedOn DESC.