London Dev Meetup Rescheduled! Due to unavoidable reasons, the event has been moved to 21st May. Speakers remain the same—any changes will be communicated. Seats are limited—register here to secure your spot!

AI OnAI Off

Sql query to tblNotificationSubscription uses 100% Azure CPU

Daniel
Daniel
Vote:
0

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:
0

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:
0

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.