Azure SQL DB high resources consumption issue with nopCommerce 3.8

After migration to Azure SQL DB I've noticed very strange resource consumption pattern for a database with several spikes per day.



Here is what I can see in Query Performance Insight under Resource consuming queries

and Long running queries.


Here is query ID 896 which is causing most of the problems

(@p0 int)SELECT TOP (2) 
    [Extent1].[Id] AS [Id], 
    [Extent1].[PictureBinary] AS [PictureBinary], 
    [Extent1].[MimeType] AS [MimeType], 
    [Extent1].[SeoFilename] AS [SeoFilename], 
    [Extent1].[AltAttribute] AS [AltAttribute], 
    [Extent1].[TitleAttribute] AS [TitleAttribute], 
    [Extent1].[IsNew] AS [IsNew]
    FROM [dbo].[Picture] AS [Extent1]
    WHERE [Extent1].[Id] = @p0

Is it bug or feature?
Any ideas why it is happening or how it could be fixed?

Speed in Azure was increased in version 3.90. Please try it. And more changes are coming in version 4.00 (details)

Please also set "Pictures are stored into...file system" on the media settings page.

a.m. wrote:

Awesome news Andrei! Very excited about 4.0 cz we've just started planning a new project that gonna be with much higher loads than the current one.

Just wasn't sure about the cause of my issue and possible fix.