ASP.NET,SQL server loading issue RRS feed

  • Question

  • I have a page (ASP.NET) that's contains stored procedure that is loading slowly, but when i execute this stored procedure directly from SQL server it runs fast

    how to fix this issue?

    Monday, September 7, 2020 9:12 AM

All replies

  • Hello,

    There are many reasons for this, see the following which discuss settings, using execution plan and more.


    Please remember to mark the replies as answers if they help and unmarked them if they provide no help, this will help others who are looking for solutions to the same or similar problem. Contact via my Twitter (Karen Payne) or Facebook (Karen Payne) via my MSDN profile but will not answer coding question on either.

    NuGet BaseConnectionLibrary for database connections.

    profile for Karen Payne on Stack Exchange

    Monday, September 7, 2020 12:35 PM
  • Executing Web code on a Web server to access the database is  far different than you directly executing the T-SQL with SSMS at the database level using a sproc or not.

    Also consider what is being talked about in the links and slow Web program performance concerning database access.



    Monday, September 7, 2020 9:40 PM
  • Hi rim jd,

    As your question is related to ASP.NET, I suggest you post on ASP.NET forums for more help.

    Thank you for your understanding.

    Best Regards,

    Xingyu Zhao

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Tuesday, September 15, 2020 7:07 AM