November Happy Hour will be moved to Thursday December 5th.

AI OnAI Off

Sql query to tblNotificationSubscription uses 100% Azure CPU

Daniel
Daniel
Vote:
 

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:
 

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:
 

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.