locked
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.

    http://www.sommarskog.se/query-plan-mysteries.html


    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.

    StackOverFlow
    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.

    https://dzone.com/articles/reasons-move-datatables

    http://lauteikkehn.blogspot.com/2012/03/datatable-vs-list.html

    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