经典ASP应用程序在数据库迁移后响应非常缓慢。 [英] Classic ASP application is responding very slowly after database migration.

问题描述

大家好，



我们有经典的ASP应用程序，最近我们将数据库从一台服务器迁移到另一台服务器。与迁移之前相比，此迁移活动应用程序响应速度非常慢。



以前的服务器有SQL Server 2005，最近迁移的服务器有SQL Server 2008.



请帮帮我必须检查/更改以尽快回复它。



谢谢&此致，

Ramesh



我尝试过：



验证.inc文件和web.config文件中的连接字符串设置。

Hi All,

We have classic ASP application, recently we migrated database from one server to another server. After this migration activity application is responding very slowly as compared with before migration.

Previous server has SQL server 2005, recently migrated server has SQL server 2008.

Please help me where has to check/change to respond it quickly as earlier.

Thanks & Regards,
Ramesh

What I have tried:

Verified connection string settings in .inc file and web.config files.

推荐答案

如果以前的数据库与IIS位于同一台计算机上，问题是，对数据库的任何调用现在必须通过网络传输。尽量减少要执行的查询数量，例如使用适当的 JOIN 表在一个查询中查询一个表的记录和另一个表中的相关行，而不是一个表中的记录，后面跟一个查询查询其他表中的详细信息每行的表。

还要检查迁移时是否没有遗漏某些键/索引。

If the previous database was located on the same machine with IIS, the problem is that any call to the database must now travel over the network. Try to minimize the number of queries to be executed, e.g. with appropriate JOINs of tables querying records of one table and dependent rows from another table in one query, instead of records from one table followed by one query for the details in the other table for each row.
Also check that you did not miss some keys / indices when migrating.

这篇关于经典ASP应用程序在数据库迁移后响应非常缓慢。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！