How to find where my asp.net website is getting slow

I have 3.5 .net website. It's online billing website where clients download pdf, excel files.
Recently the table showing billing record got very slow. I ran the SQL query to database, the result comes up normally. I suspect the problem is somewhere in web server or the code itself because the code searches the client's directory and if there's pdf file, it doesn't create the receipt or excel file, but reuse it. In web server IIS, is there any way to find or test what is causing this problem?

2003 STD IIS, .NET 3.5
LVL 1
crcsupportAsked:
Who is Participating?
 
Kusala WijayasenaConnect With a Mentor Software EngineerCommented:
Just download the ANTS Performance Profiler 8 (trial is fine) and check what was cause for the matter
0
 
Hiran DesaiConnect With a Mentor Solution ArchitectCommented:
You can use enable tracing in your page or at Application Level.
For page level
<%@ Page Trace="true" %>

Open in new window

For Application level
<configuration>
  <system.web>
    <trace enabled="true" pageOutput="false" requestLimit="40" localOnly="false"/>
  </system.web>
</configuration>

Open in new window


This gives you information about each event execution and amount of time it takes.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.