Troubleshooting an ASP.net page running a SQL Query that spins indefinitely

April Lee-Newton 1 Reputation point
2021-11-15T13:51:40.95+00:00

I am trying to load an ASP.net/Razor page created in Visual Studio .NET 3.0 framework that pulls from a SQL stored procedure, and the page is "stuck" in the loading phase after 5 minutes. The stored procedure takes 32 seconds in SQL Server Management Studio. I am new to indexes and when I run the estimated execution plan, it does not give me any missing index details. Is there a way to troubleshoot what the issue is exactly, and how I can I get my webpage to load quickly? The entire record set is about 60,000 records.

ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
3,288 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Lan Huang-MSFT 25,876 Reputation points Microsoft Vendor
    2021-11-16T05:52:04.287+00:00

    Hi @April Lee-Newton ,
    First, does the 32-second stored procedure refer to 1 piece of data or 60,000 pieces of data?
    Second, to speed up page loading, you need to check which events take a long time.
    Then, I think you can enable browser caching.
    Browser caching is another form of caching that can be used to increase page loading speed. This technology enables the browser to store a variety of information, including style sheets, images, and JavaScript files, so there is no need to reload the entire page every time the user visits.
    Best regards,
    Lan Huang

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments
  2. April Lee-Newton 1 Reputation point
    2021-11-16T14:34:48.467+00:00

    Thank you. The stored procedure pulls about 200 columns and 60,000 rows. Is there an application or tool I could use to check which events are taking a long time? I also want this page to load for other employees in the district, so I am not sure if browser caching would be a solution for them.