IIS 7 and Above
Any free tool to troubleshoot ASP.NET performance issue?
Last post Feb 26, 2019 04:29 AM by lextm
Feb 26, 2019 04:24 AM|gaomaque|LINK
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
Feb 26, 2019 04:29 AM|lextm|LINK
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.