应用响应缓慢 [英] Application Response Slow

问题描述

大家好，



我的ASP.Net网络应用程序托管在一台服务器上（稍后会发布），几天或者几个月后我就可以了我遇到的问题是我在应用程序屏幕上出现间歇性的超时。有时当我点击搜索按钮时，我会在几秒钟内得到结果，有时相同的功能需要7-8分钟，然后显示超时。



现在我正在谈论托管在共享服务器上并使用Oracle数据库的Web应用程序。我不知道这是Oracle数据库问题还是与网络流量或服务器使用情况或CPU利用率有关的问题，但我迫切需要提出一个解决方案或者至少一些指示网络团队来检查关于这个问题。



如果是应用程序问题，我会在使用该功能时遇到同样的问题但事实并非如此。 />


这方面的任何帮助都将受到高度赞赏



谢谢！

Hi All,

My ASP.Net web application is hosted on a server (coming to this later) and since couple of days or may be months now I am facing a problem that I am getting intermittent time outs in the application screens. At times when I click on a Search button, I get results within seconds and at times the same function takes 7-8 minutes and then shows a time out.

Now I am talking in terms of a web application which is hosted on shared servers and using a Oracle database. I do not have any idea if this is a Oracle db issue or something related to Network Traffic or server usage or CPU utilization but I am in a dire need of bringing up, either a solution or at least some pointers for the network team to check on this problem.

Had it been a application issue, I would have faced the same issue all the time I used the functionality but that is not the case.

Any help in this regards would be highly appreciated

Thanks !

推荐答案

使用日志工具之一，如 log4net [ ^ ]并记录搜索开始时间和搜索输入的详细信息，如果有任何异常日志完整异常详细信息，搜索结束时间等。 。

你可以找到很多关于如何在ASP.NET中配置和使用log4net的文章

使用ASP.NET 3.5的Log4Net - 文件附加程序 [ ^ ]



以及日志文件中的上述信息，您可以轻松找到问题。

use one of logging tool like log4net[^] and log the details of search start time and search inputs, if any exception log full exception details, search end time etc..
you can find many articles about how to configure and use log4net in ASP.NET
Log4Net with ASP.NET 3.5 – File Appender[^]

with above information on your log file you can easily find the issue.

Hello GP，

Hello GP,

当我点击搜索按钮时，我会在几秒钟内得到结果，有时相同的功能需要7-8分钟，然后显示超时。

At times when I click on a Search button, I get results within seconds and at times the same function takes 7-8 minutes and then shows a time out.

这表明您应该查看搜索查询。查看用户单击搜索按钮时运行的SQL查询。使用SQLPlus运行查询并查看返回结果是否需要时间。如果是这样，那么您需要调整查询。以下文章可以帮助您理解查询调优。

• SQL调优或SQL优化 [ ^ ]
• 调整性能PL / SQL应用程序 [ ^ ]
• Oracle SQL调优 - 调整单个SQL语句 [ ^ ]

This indicates to me that you should be looking at the search query. Look at the SQL Query that runs when user clicks on the search button. Use SQLPlus to run the query and see whether it takes time to returns the results. If so then you need to tune the query. Following articles may help you in understanding the query tuning.




• SQL Tuning or SQL Optimization[^]
• Tuning PL/SQL Applications for Performance[^]
• Oracle SQL tuning - Tune individual SQL statements[^]




这篇关于应用响应缓慢的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！