×

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

@Florida

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

  • 看大家讨论日语，俺也正在认真学习。其实语言问题应该是很快也很容易就解决的，可能比自动驾驶来的还快。TREK里面，全宇宙的人都在大脑里安装了UNIVERSAL TRANSLATOR，外星人之间相互交流无障碍。废话少说，看视频。。。加上个MIC和耳机，不同国家的人就可以无障碍交流。
  • 肉脸真有搞 IT 的？Linux 把俄国中国伊朗踢出去了好像肉脸 IT 没啥感觉似的
  • 请问web developer和software developer技术上有什么区别？
  • Elon Musk 带着川普总统奔向火星了。
  • 扔硬币的实验研究
    • 枫下论坛主坛 /  工作学习 /  学科技术讨论