Any free tool to troubleshoot ASP.NET performance issue?RSS

1 reply

Last post Feb 26, 2019 04:29 AM by lextm

  • Any free tool to troubleshoot ASP.NET performance issue?

    Feb 26, 2019 04:24 AM|gaomaque|LINK

    Hello,

    We have an ASP.NET 4.5 web application hosted in Windows Server 2012 R2 with IIS 8.5. The database was hosted on SQL Server 2008, and everything looked fine. Recently, we migrated our database from the SQL Server 2008 to another SQL Server 2014 box. We took a database backup and restore the same to SQL Server 2014. After that, we got a performance issue. The web pages become slower and slower and finally timed out. The DBA team found very high CPU utilization of the SQL Server 2014 database. But if we change the database connection string from the new SQL 2014 to the old SQL 2008 in Web.config, everything becomes normal. My question is, is there any free tool running on IIS web server to troubleshoot this performance issue? For example, to check the database connection status, etc..

    Thanks,
    高麻雀

  • Re: Any free tool to troubleshoot ASP.NET performance issue?

    Feb 26, 2019 04:29 AM|lextm|LINK

    gaomaque

    The DBA team found very high CPU utilization of the SQL Server 2014 database.

    When the issue is so obvious on database side, why cannot they use tools like SQL Server Management Studio to learn what might be wrong? It is kind of misleading to go back to ASP.NET at this very moment, as ASP.NET threads can be slow and wait for responses from database side.

    Lex Li
    IIS Consulting Services at https://support.lextudio.com/services/consulting.html
    ---------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.