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..
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
https://lextudio.com
---------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
8 Posts
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,
高麻雀
8522 Posts
MVP
Re: Any free tool to troubleshoot ASP.NET performance issue?
Feb 26, 2019 04:29 AM|lextm|LINK
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.
https://lextudio.com
---------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
19 Posts
Re: Any free tool to troubleshoot ASP.NET performance issue?
Jun 10, 2019 09:00 PM|Akshay_M|LINK
Here are the tools we'll cover in this post:
Regards,
Developer | CloudDesktopOnline