How to detect the slow speed of an ASPX page

Recently read an article about how to improve the speed of an ASPX page. This is a common interview problem. The problem originates from this website.

There are a variety of reasons for this problem, and we need a step-by-step troubleshooting to locate where the problem really occurs.

1. Find out if the piece is slow, whether the Web site itself or the database is interacting slowly. If the page is performing interactions with the database, extract the SQL commands to run with the database console. If the execution of these statements on the database console is still slow, then the problem is that you are on top of the interaction with the database, and you need to consider optimizing the SQL statements.
A. Check to make an index to improve query speed
B. Using SELECT * will reduce efficiency
C. Use the Join keyword as little as possible

2. If the SQL statement executes quickly, then the problem is likely to be on the site itself. At this point we need to look at each page event to determine which one is performing slowly. In ASP. There is a tracing tool that we can use to see how long each event takes. Set trace= "true" in page directive, and you will be able to see the list of time parameters for each event at the bottom of the page.

How to detect the slow speed of an ASPX page