SaaS CMS has officially launched! Learn more now.

Sql query to tblNotificationSubscription uses 100% Azure CPU



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

Edited, Apr 28, 2023 11:32

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

May 01, 2023 8:18

I will check that. Thanks

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.