Last post May 30, 2018 12:53 PM by markfitzme
May 27, 2018 04:14 AM|issam1975|LINK
i have a web forms projects that use an asmx data backend on sql server and entity framework 6 (db first)
there is also some web controls that use code behind to display data.
one page that display the data from the database take a very long time .
is there a way or a tool that monitor the page life cycle (client side or server side) and show the exact location of the portion that take the most time of rendering .
my guess is that its EF6 related server side thing, but i am not sure .
any idea is welcome .
May 27, 2018 06:03 AM|DA924|LINK
You may want to use DTO(s) to reduce unnecessary data you may be bringing in the EF Entities.
May 30, 2018 07:52 AM|issam1975|LINK
thanks for the answer .
but i am looking for some performance profiler tool .
i have just downloaded ant software to test it .
does visual studio have something similar like the wpf profiler tool but for asp.net ?
i am using VS 2015 community edition for web developpement but i can switch to another version id needed .
May 30, 2018 12:53 PM|markfitzme|LINK
If you are talking to a sql server, try using SQL Profiler to monitor the communication. You could find that the queries are overly chatty or including things you didn't expect or doing individual fetches for a lookup table instead of loading all the results
Also, watch the F12 tools in your browser, specifically the networking, you may be able to identify some other resource that is taking a while to load.