locked
why does my page rendering take sooooooo long? RRS feed

  • Question

  • User-511995934 posted

    i have an asp.net website that allows users to do a search

    the search hits a sql server database and returns a list of records. this search, for the past 6 months has taken roughly 10 seconds. suddenly, it now takes over a minute to return the same records as before. in TEST and DEV it still takes 10 seconds. they all hit the same database and are returning the same set of records. the code between all three is exactly the same. this led me to believe the problem MUST be the prod server itself. we turned on the resource manager and watched the prod server's performance measures as the search takes place. memory: 2% cpu usage: 20% paging is also very low

    any ideas???

    Friday, February 26, 2016 3:21 PM

Answers

  • User-219423983 posted

    Hi threeo,

    they all hit the same database and are returning the same set of records. the code between all three is exactly the same. this led me to believe the problem MUST be the prod server itself.

    According to your description, I guess the three servers connect to the same database. There are 3 IIS Servers and only 1 database in your situation. If I’m wrong, please let me know.

    If I’m right, I think it’s not a good practice to build the architecture. You’d better let the Test and Dev applications connect to the same database and let the Prod Server connect to a separate Prod database.

    About why the Prod Server cost long time to render the page, there would be many reasons. As usual, you could first refer to the following links to set and view the IIS log file to check the Response time through the Time-Taken field. The Time-Taken field shows the length of time that it takes for a request to be processed and its response to be sent. For this, you could click here to learn more things.

    https://www.iis.net/configreference/system.applicationhost/sites/sitedefaults/logfile

    If there’s no significant differences between the Time-Taken of three servers, you could check the Network circumstance of the Prod server, the speed of connecting to the database and the speed of connecting to the client. Or, you could check whether it’s related to the Firewall.

    Besides, you could have a look at the following links to learn how to use the Browsers to monitor the Render time of a page and then find out which process takes the long time.

    https://msdn.microsoft.com/en-us/library/dn255004(v=vs.85).aspx

    http://serverfault.com/questions/412419/iis-how-to-tell-if-a-slow-time-taken-is-due-to-a-slow-network-connection

    Best Regards,

    Weibo Zhang

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, March 1, 2016 7:04 AM

All replies

  • User-1315512054 posted

    Hello,

    You could connect manually from production server to the SQL server and to make the query to see the result time. If this is not the problem, then you should check your application settings.

    Regards

    Friday, February 26, 2016 8:16 PM
  • User-219423983 posted

    Hi threeo,

    they all hit the same database and are returning the same set of records. the code between all three is exactly the same. this led me to believe the problem MUST be the prod server itself.

    According to your description, I guess the three servers connect to the same database. There are 3 IIS Servers and only 1 database in your situation. If I’m wrong, please let me know.

    If I’m right, I think it’s not a good practice to build the architecture. You’d better let the Test and Dev applications connect to the same database and let the Prod Server connect to a separate Prod database.

    About why the Prod Server cost long time to render the page, there would be many reasons. As usual, you could first refer to the following links to set and view the IIS log file to check the Response time through the Time-Taken field. The Time-Taken field shows the length of time that it takes for a request to be processed and its response to be sent. For this, you could click here to learn more things.

    https://www.iis.net/configreference/system.applicationhost/sites/sitedefaults/logfile

    If there’s no significant differences between the Time-Taken of three servers, you could check the Network circumstance of the Prod server, the speed of connecting to the database and the speed of connecting to the client. Or, you could check whether it’s related to the Firewall.

    Besides, you could have a look at the following links to learn how to use the Browsers to monitor the Render time of a page and then find out which process takes the long time.

    https://msdn.microsoft.com/en-us/library/dn255004(v=vs.85).aspx

    http://serverfault.com/questions/412419/iis-how-to-tell-if-a-slow-time-taken-is-due-to-a-slow-network-connection

    Best Regards,

    Weibo Zhang

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, March 1, 2016 7:04 AM