×

Loading...
Ad by
  • 最优利率和cashback可以申请特批，好信用好收入offer更好。请点链接扫码加微信咨询，Scotiabank -- Nick Zhang 6478812600。
Ad by
  • 最优利率和cashback可以申请特批，好信用好收入offer更好。请点链接扫码加微信咨询，Scotiabank -- Nick Zhang 6478812600。

@Calgary

ASP.NET Site Performance Problem, please help!

dongdongca(DongDong)
本文发表在 rolia.net 枫下论坛请各位高手帮我分析分析:
最近刚加入一家公司,第一个星期就碰到这个棘手问题, 我们SUPPORT的APPLICATION开始出现PERFORMANCE问题. Production environment - load balancer with two web servers, talk to application server, applcation server talk to SQL DB server. NET 2.0 web application, SQL Server 2000 backend database, around 4000 end users, most web pages are loaded with big chunk of data from complex query/stored procedures; application uses connection pooling (max pool size=1000,connect timeout=60) .
The problem occurs on 14th of every month, because emails with report links are sent out, many users click those links and login to the site and load reports, start from 10AM to 11AM 形成 peak hours, application becomes very slow or even not responding at all, some users get timeout errors, some get connection related errors.
从Web statistics上看(以下数据只是大概),
8 AM - 20 Hits Response Time: 3 secs
9 AM - 40 Hits Response Time: 6 secs
11AM - 156 Hits Response Time: 30 secs
12AM - 180 Hits Response Time: 45 secs
1PM - 110 Hits Response Time: 60 secs
2PM - 50Hits Response Time: 60 secs
3PM - 30Hits Response Time: 60 secs
4PM - 10Hits Response Time: 60secs
后来他们做了IISRESET,Server才恢复正常. 症状就是: web server 在peak hours 时很慢很慢,基本不工作, 奇怪的是 peak hours 之后Web Serer 还没有恢复正常.

请大家建议我应该怎么诊断好, 因为是production, 我能拿到的信息很有限. 如果要解决的话, 有没有好的solution?
谢谢!!更多精彩文章及讨论，请光临枫下论坛 rolia.net
(#5572232@0)
Last Updated: 2009-9-26
This post has been archived. It cannot be replied.
Report

Replies, comments and Discussions:

  • 工作学习 / 学科技术讨论 / ASP.NET Site Performance Problem, please help! -dongdongca(DongDong); 2009-9-26 {1503} (#5572232@0)
    本文发表在 rolia.net 枫下论坛请各位高手帮我分析分析:
    最近刚加入一家公司,第一个星期就碰到这个棘手问题, 我们SUPPORT的APPLICATION开始出现PERFORMANCE问题. Production environment - load balancer with two web servers, talk to application server, applcation server talk to SQL DB server. NET 2.0 web application, SQL Server 2000 backend database, around 4000 end users, most web pages are loaded with big chunk of data from complex query/stored procedures; application uses connection pooling (max pool size=1000,connect timeout=60) .
    The problem occurs on 14th of every month, because emails with report links are sent out, many users click those links and login to the site and load reports, start from 10AM to 11AM 形成 peak hours, application becomes very slow or even not responding at all, some users get timeout errors, some get connection related errors.
    从Web statistics上看(以下数据只是大概),
    8 AM - 20 Hits Response Time: 3 secs
    9 AM - 40 Hits Response Time: 6 secs
    11AM - 156 Hits Response Time: 30 secs
    12AM - 180 Hits Response Time: 45 secs
    1PM - 110 Hits Response Time: 60 secs
    2PM - 50Hits Response Time: 60 secs
    3PM - 30Hits Response Time: 60 secs
    4PM - 10Hits Response Time: 60secs
    后来他们做了IISRESET,Server才恢复正常. 症状就是: web server 在peak hours 时很慢很慢,基本不工作, 奇怪的是 peak hours 之后Web Serer 还没有恢复正常.

    请大家建议我应该怎么诊断好, 因为是production, 我能拿到的信息很有限. 如果要解决的话, 有没有好的solution?
    谢谢!!更多精彩文章及讨论，请光临枫下论坛 rolia.net
    • memory leak? -hkchan(0); 2009-9-26 (#5572317@0)
    • read this article and let us know the results. -hkchan(0); 2009-9-26 (#5572329@0)
      • Thanks a lot, will check it out Monday. -dongdongca(DongDong); 2009-9-26 (#5572903@0)

More Topics

  • 现在社区游泳池招救生员巡逻，过一会还要不停的点人头，这工作是否很快就被AI代替了，装一个摄像头后面是AI处理系统，这样只招一个等着救人就行了，人头沉下水一定时间立马强光照射，还可以分析水下人的状况来判断是否溺水等
  • 新冠疫苗引发心肌炎? 最新研究这样看
  • 这道几何题有解吗?
  • SAM 2 Demo
  • 如何在 AWS EC2 实例上构建 WordPress 应用程序?
    • 枫下论坛主坛 /  工作学习 /  学科技术讨论