performance issues debugging tools ?

Question

User-921158202 posted

hi,

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 .

thanks

Answer 1

User1120430333 posted

i have a web forms projects that use an asmx data backend on sql server and entity framework 6 (db first)

my guess is that its EF6 related server side thing, but i am not sure .

https://msdn.microsoft.com/en-us/library/hh949853(v=vs.113).aspx

https://www.red-gate.com/simple-talk/dotnet/net-tools/entity-framework-performance-and-what-you-can-do-about-it/

You may want to use DTO(s) to reduce unnecessary data you may be bringing in the EF Entities.

https://www.codeproject.com/Articles/1050468/Data-Transfer-Object-Design-Pattern-in-Csharp

https://docs.microsoft.com/en-us/dotnet/csharp/programming-guide/classes-and-structs/auto-implemented-properties

https://docs.microsoft.com/en-us/dotnet/framework/debug-trace-profile/performance-counters

https://blogs.msdn.microsoft.com/diego/2012/03/31/tips-to-avoid-deadlocks-in-entity-framework-applications/

Answer 2

User-921158202 posted

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 .

Answer 3

User465171450 posted

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 at once.

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.