如何配置一个经典的 ASP 网站? [英] How to profile a classic ASP web site?

问题描述

我有一个运行缓慢的经典 ASP (JScript) 网站，是否有任何分析器可以帮助我确定什么需要时间?

I have a classic ASP (JScript) web-site that is running slow and are there any profilers that can help me identify what is taking time?

有关如何优化或调试 ASP 性能问题的其他提示会有所帮助.

Other hints on how to optimize or debug ASP performance issues would be helpful.

推荐答案

假设您正在寻找免费的解决方案，以下是我过去(非常老的)项目中使用的一些建议:

Assuming you're looking for free solutions, here are some suggestions used in past (very old) project of mine:

ASP Profiler 组件.这是 Active Server Pages(使用 VBScript)代码的行级性能分析器.它显示了您的 ASP 页面是如何运行的，哪些行被执行了多少次，以及每行需要多少毫秒.特别是对于大量数据驱动的页面，您可以准确地看到哪些行会减慢页面速度，并在必要时进行优化.

ASP Profiler component. This is a line-level performance profiler for Active Server Pages (with VBScript) code. It shows how your ASP page runs, which lines are executed how many times, and how many milliseconds each take. Especially for heavy data-driven pages, you can see exactly which lines slow down the page, and optimize where necessary.

谷歌搜索我还发现了几篇关于计时/分析 ASP 执行代码的非常古老的文章:看看 这里和这里.

Googling around I have also found a couple of very old articles on timing/profiling ASP execution code: have a look here and here.

如果您遇到服务器端代码运行缓慢的问题，我发现几乎总是数据库导致问题.您需要检查返回结果较慢的 SQL；如果您发现任何需要考虑将新索引应用于您的表.如果您的应用程序与数据库过于繁琐，您需要考虑减少对数据库的调用次数.要查找这些问题，您始终可以使用 SQL Server Profiler；这与 SQL Server 2005/2008 开发人员版捆绑在一起.

If you have an issue with server side code being slow I have found it is almost always the database causing the issue. You need to check for SQL which is slow to return a result; if you find any you need to look at applying new indexes to your tables. If your app is too chatty with the database you need to look at reducing the number of calls to the database. To find these problems you can always use SQL Server Profiler; this comes bundled with SQL Server 2005/2008 Developer edition.

您还可以使用 xsqlsoftware.com

这篇关于如何配置一个经典的 ASP 网站?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！