Try our conversational search powered by Generative AI!

Why does aspnet_Profile_GetProperties get called on every request in edit mode



We've had performance issues that I've posted here: 

Now, I managed to get further ahead with profiling and I've noticed that on every request in edit mode (ex.  /xx/cms/Stores/contentstructure, /xx/cms/Stores/sitestructure/..), database gets hit calling aspnet_Profile_GetProperties. Is there something I can do about this? This is just a part of requests, but you can see a database icon on the right:

I'll also get the info to support, but if anyone has an idea, let me know.



Edited, Nov 24, 2016 16:21

I should also mention that the query that is caught by the profiler has the date format that is not recognized when I try to execute it directly in SQL manager studio, but the profiler doesn't mark this as erronious and might be that it just presents the date wrong.

This is the query for the sake of completeness:

EXEC dbo.Aspnet_profile_getproperties
@ApplicationName = 'EPiServerSample', @UserName = 'username', @CurrentTimeUtc = '2016-11-24T15:14:26.3079162Z'



Nov 24, 2016 16:24


I just got a notification that the fix for this will be released with version 10.6.0 if anyone is wondering.

Feb 09, 2017 11:12

Hi Marija,

Thank you for all your information on this problem.

We have had the same issues, that were indeed increased by Projects as you said in and your posts have been most helpful.

Are you working around it in some way atm, and did you get any hints on when 10.6.0 could be released with this much needed fix?

Feb 17, 2017 12:27

Hi, Marie,

I've only improved overall performances of the app, I didn't build a workaround. I tried to turn off the sqlprofile in web.config, but it is required (I do not remember what for, but I am pretty sure I couldn't live without it). I had an idea of rewriting this to my own implementation, but didn't have time to do so. I believe that it's the best to wait for the fix and I doubt we can get a definitive answer on the release date, but I guess it will be there pretty soon. Perhaps a bit delayed due to Ascend Vegas.

Not a fix from me, but hope this helps as well :)

Feb 17, 2017 18:33

Ok, thank you. :)

Feb 20, 2017 10:59

CMS UI 10.6.0 is now available.

Feb 21, 2017 20:06
This topic was created over six months ago and has been resolved. If you have a similar question, please create a new topic and refer to this one.
* 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.