volume_up

A critical vulnerability was discovered in React Server Components (Next.js). Our systems remain protected but we advise to update packages to newest version. Learn More. 

AI OnAI Off

Sql query to tblNotificationSubscription uses 100% Azure CPU

Daniel
Daniel
Vote:
expand_less 0 expand_more

Hi,

Have you ever met the problem with Azure SQL database cpu 100% usage caused by query to tblNotificationSubscription? This causes "-2" code response on Azure.

There is no custom query to this table, just some inbound episerver feature calls this. This happens randomly.

CMS 11.15.1

#300891
Edited, Apr 28, 2023 11:32
Quan Mai
Quan Mai
Vote:
expand_less 0 expand_more

Is your site running on DXP? 

It might be a good idea to try to rebuild your db indexes, if it is not already done

#301012
May 01, 2023 8:18
Daniel
Daniel
Vote:
expand_less 0 expand_more

I will check that. Thanks

#301836
May 15, 2023 7:23
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.