ASP.NET,SQL server loading issue

All replies

• 

  

  0

  Sign in to vote

  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
  

  Monday, September 7, 2020 12:35 PM
• 

  

  0

  Sign in to vote

  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
• 

  

  0

  Sign in to vote

  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