I'm working on a large ASP.NET application on my local machine (IIS7, local SQL Server 2014, ASP.NET 4.6.2).

Since a few days, this application usually loads ok (kind of) after a clean/build operation, but starts taking forever (and thus getting frequent timeouts) after a few clicks or after a standard build.

I wasn't able to find what is happening, the CPU is mostly idle, SQL server is reactive (and works ok from SSMS), IIS doesn't have any hanging request except for the current one.

Of course, the same code executed on another computer (same model) with the same configuration (IIS and SQL Server versions, same database) works correctly.

Sorry I don't have any more information to provide, I'm a little clueless here.

Is there some stuff I can check ?

Please ask for more information if needed.

  • Have you tried to debug or profile it? – user996142 Apr 27 '18 at 13:43
  • I didn't profile it, but I debug it regularly, but this doesn't help, the behavior is the same. As said, the code is functional, and acceptably efficient on another identical platform. – xlecoustillier Apr 27 '18 at 13:47
  • Can you debug it on this IIS, pause it, and check thread stacks to find where exactly thread stopped? – user996142 Apr 27 '18 at 14:42
  • It hangs on a huge (and certainly for from optimal) SQL query. What remains to find out is why this query doesn't almays take ages on the same dataset, but I guess I can work from there. Thanks :) – xlecoustillier May 11 '18 at 8:02

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.