在服务器上运行的网站的性能问题 [英] Performance Issue of a website which is running at the server

问题描述

亲爱的所有人，

我们有两个使用ASP.Net(vs2008)和sql server 2008创建的网站.
我们将这些网站托管在同一服务器上.但是一个站点的速度不错，而另一个站点的性能却太慢.

任何人都可以告诉我可能是什么问题吗?

问候，

Dear All,

We have two web sites created using ASP.Net(vs2008) and sql server 2008.

We hosted these web sites in the same server. But the speed of one site is good and the other is too slow in performance.

Can any one please tell me what might be the issue?

Regards,

推荐答案

在数据库中执行查询并使用探查器对其进行分析.
分析ASP以进行服务器往返.
检查数据库视图是否正确使用也很好

Execute the queries in Database and use profiler to analyse it.
Analyse the ASP for round trips from server.
Also good to check if database views are used properly

这不可能完全告诉您问题出在哪里，但是，您绝对可以自己进行一些性能分析.

听起来好像网站访问缓慢的数据库可能存在一些问题.尝试排除数据访问瓶颈.

您的查询执行得好吗?所有表都正确索引了吗?也许对数据库运行SQL事件探查器，看看是否有任何运行缓慢的查询，是否发生任何表扫描?

也许针对您知道正在执行的某些SQL运行查询事件探查器. (在SQL Management Studio中，将SQL放在查询窗口中，然后选择查询"->显示估计的执行计划").看一下查询计划，您能看到查询花费大量时间的任何统计信息吗?

您需要确保其运行速度尽可能快-错误的表或效率低下的查询确实会减慢您的网站的速度

如果您可以完全排除数据库的罪魁祸首，那么我们将继续研究网站之间的差异！

It''s impossible to tell you exactly what the problem is, however - you can definitely do some performance analysis yourself.

It sounds like the database the slow website is accessing might have some issues. Try and rule out data access as a bottle neck.

Are your queries executing well? Are all the tables indexed correctly? Perhaps run SQL profiler against the database and see if there are any slow running queries, any table scans occurring ??

Maybe run query profiler against some SQL you know is being executed. (in SQL Management Studio, put SQL in query window and choose Query -> Display Estimated Execution Plan). Look at the query plan, can you see any statistics where queries are spending a lot of time?

You need to make sure this is running as fast as possible - Bad table or ineffiecient queries will really slow down your site

If you can totally rule out the database as the culprit, then we''ll move onto looking at the differences between the websites!

这篇关于在服务器上运行的网站的性能问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！