Production site performance
-
I've this production site that's performing very slow for every action. We've checked database side and database is tuned and queries, when they reach the SQL Server - performs fine. There's little bit of time difference when it runs in query analyzer and when it comes from the web - say 2 seconds. But that doesn't explain why it takes 30 seconds just to login. So we are trying to troubleshoot it. Is Fiddler or any other tool might be helpful here? Thanks.
-
I've this production site that's performing very slow for every action. We've checked database side and database is tuned and queries, when they reach the SQL Server - performs fine. There's little bit of time difference when it runs in query analyzer and when it comes from the web - say 2 seconds. But that doesn't explain why it takes 30 seconds just to login. So we are trying to troubleshoot it. Is Fiddler or any other tool might be helpful here? Thanks.
-
What technology? ASP.NET? Java? Php? Ruby? When asking questions like this, always furnish all the available and relevant information.
-
Hello Shameel, It's ASP .NET (.NET Framework 4.0) and Entity Framework V5 in combination with WCF web services. SQL Server 2008 R2 back end. Hope that helps. Thanks.
Still relevant code & query is missing
thatraja
-
Still relevant code & query is missing
thatraja
-
It happens for every action. So it is a general problem, not related with any specific query or code. Same code performs much faster in development environment. So - what I'm looking for is any tool(s) that can help investigate the issue. Thanks.
The best way is you should check the log files(Eventlog, IIS, SQL server, log file created by you) to find strange things. Enable tracing in your application & track the issue. My guess: I think possibly firewall issue or IIS pool. Check these ASP.NET application on IIS7 - very slow startup after iisreset[^] Slow first page load on asp.net site[^] Steps to troubleshoot SQL connectivity issues[^] ! Very Slow ASP.NET Response  To improve things, ASP.NET Optimization[^]
thatraja
-
The best way is you should check the log files(Eventlog, IIS, SQL server, log file created by you) to find strange things. Enable tracing in your application & track the issue. My guess: I think possibly firewall issue or IIS pool. Check these ASP.NET application on IIS7 - very slow startup after iisreset[^] Slow first page load on asp.net site[^] Steps to troubleshoot SQL connectivity issues[^] ! Very Slow ASP.NET Response  To improve things, ASP.NET Optimization[^]
thatraja