Hi Umbraco,

We are currently investigating what is going on with our Umbraco 8 application because of the high CPU usage. We tried to do the debugging using Diagnostic tools provided by Microsoft Visual Studio 2019.

Apparently, we found high CPU usage in the code to get data from Database. One of the examples :

using (var scope = _scopeProvider.CreateScope())
            {
                memberCVs = scope.Database.Query<MemberCV>()
                    .Include(x => x.CVTemplate)
                    .IncludeMany(x => x.SharedCVs)
                    .Where(i =>
                        i.MemberId == memberId &&
                        i.EditStatusId != CVEditStatus.TRASH
                    )
                    .ToList();
                scope.Complete();
            }

And this is the result from Diagnostic tools :

For your information, we never modified the original Umbraco tables. We did add several tables to the Umbraco database, and did the model mapping like so :

Is there anything we did wrong that caused this issue ? Thank you.