How can i get the time of each execution in my asp.net website?
<p>I have a asp.net website in my local IIS and one of a page takes a very lone time(about 10 seconds) to be loaded because of a sql query(this sql query takes about 7 seconds). I did some tuning works and finally make this sql query takes less than 1 second. But the page still takes about 3 seconds to complete the loading and i think it's still slow.This page got "B" in the yslow test,so i guess there must be some CLR executions in this page takes these time,but how can i get the time of these executions(loops or variables declarations)? Is there any tool helpful? Thanks!</p>
