应用与数据库性能变慢... [英] Application & Database Performance becomes slow...

问题描述

大家好，

当我在午夜运行Web应用程序时，它变得非常缓慢.每天从1:00 AM到2.30AM，数据库服务器和应用程序响应都非常晚.我无法诊断问题.任何人都可以指导我.提前谢谢.

谢谢&Regards
Jeevan.

Hi all,

When I am running my web application at midnights, it becomes very slow. Every day between 1.00AM to 2.30AM, the database server and application are responding very late. I am not able to diagnose the problem. Can anyon please guide me. Thanks in advance.

Thanks &Regards
Jeevan.

推荐答案

对于Web应用程序，大多数情况是这样的，
路径1路径2
用户----------> Web应用服务器------->数据库服务器.

当用户从1:00 AM到2:30 AM响应缓慢时，它可能是路径1(从用户到Web应用程序服务器)或路径2(从Web应用程序到数据库服务器)中的较晚响应，或者可能是同时存在.

1.使用SQL 2005 Mgmt Studio直接执行sql查询(a)在1:00 AM到2:30 AM，以及(b)在其他时间执行相同的查询.比较结果.这将使您了解DB服务器响应是否是造成此问题的原因.
2.创建一个简单的HTML页面，该页面不执行任何数据库访问.并从浏览器中调用它.同样，应该这样做(a)在1:00 AM到2:30 AM，以及(b)在其他时间使用浏览器访问该文件.比较结果.这会让您了解Web服务器在夜间是否运行缓慢.

我的经验表明，在大多数服务器中，常规维护工作(如防病毒扫描，有时对磁盘进行碎片整理，未使用的文件删除，路径安装等)会在夜间进行，在大多数情况下，这种情况在Server Administrator和系统的控制下会变慢.

换句话说，在性能监视器(控制面板->管理工具->性能)中，在1:00 AM到2:30 AM设置一个日志"，并在您没有​​看到任何此类延迟响应时将其与正常时间进行比较.比较一下.

检查出来，让我知道这篇文章是否对您有任何帮助！！！ :)

谢谢
Arindam D Tewary，

Hi,

In case of web application most scenario like this,
Path 1 Path 2
User ----------> Web Application Server -------> DB server.

When from 1:00 AM to 2:30 AM user gets a slow response, it might be late response either in Path 1 ( User to web application server ) or in Path 2(Web application to DB server) or may be in both.

1. Execute a sql query directly using SQL 2005 Mgmt Studio (a) At 1:00 AM to 2:30AM and (b) the same query in other time. Compare the result. It would give you an insight whether DB server response is creating the problem.

2. Create a simple HTML page that does not do any Data Base access. and call it from browser. Again this should be done (a) At 1:00 AM to 2:30AM and (b)the file sould be access using browser in other time. Compare the result. this would give you an idea whether web server is running slow at night.

My experience says, in most server, routine maintanance work like Anti Virus scan, sometime disk defragmenting, unused file deletion,path installing etc goes on at night which in most cases sceduled by Server Administrator and system becomes slow.

Another way, in Performance monitor (Control Panel-->Administrative Tool-->Performance) scedule a "log" at 1:00AM to 2:30AM and compare the same with normal time when you dont see any such delay in response. Compare that.

Check that out and let me know if this post helps you at all!!! :)

Thanks
Arindam D Tewary,

这篇关于应用与数据库性能变慢...的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！