I have hosted ASP.Net application on IIS server , its always throws SQL time out error, web app time out exception error, takes lots of time for initial load even landing page is simple html content asp page. Tried almost all solutions found on net, but of no use.
Also this behavior has been observed at the time of SQL hangs always.
Please suggest any tips or tricks for the same.
Loading
Sachin SinghPosted Sep 5, 2021, 7:43 AM
Shiva GoturPosted Sep 5, 2021, 7:29 AM
What I have tried:
1. Wrote events in SQL Server to find time out queries list, but found that listed all
queries are simple one liner SQL queries. They are not complicated queries.
2. Improved SQL queries re written it with needed fields instead of using *.
4. Set Command time out to zero in code.
5. Reduced size of images used in application.
6. Implemented View State - its improved speed of site loading very quickly, but
problems of hang still persist.
7. Loading .js files at last
8. Removing unnecessary/not required css, js files.
9. Rewritten hanging part of css in inline.
10. Tried posted solution on codeproject, leansentry stackiyfy.