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?