Asp.net性能问题

问题描述：

亲爱的朋友

我们使用asp.net3.5和sqlserver2008

我们使用IIS 6.0运行2003 Server SP2.我们的盒子有(2)个CPU和8 GB的RAM.

在正常负载下，我们大约有100个用户访问我们的网站.
在高峰"负载下，我们大约有300个用户，而我们的服务器阻止了我们.

在高峰负载期间，站点变得无响应且非常缓慢，或者站点没有得到适当的响应并抛出诸如
的错误
``未找到列''或
未找到表" 或

应用程序不返回任何记录，有时会返回记录，但不符合我们的搜索条件.

问候
Arvind

Dear Friends

we r using asp.net3.5 and sqlserver2008

We run 2003 Server SP2 with IIS 6.0. Our box has (2)CPU''s, and 8 GB of RAM.

Under normal load we have about 100 users accessing our web site.
Under ''peak'' load we have about 300 users, and our server is holding us back.

During peak load, the site becomes unresponsive and very slow or Not given proper response and throwing errors like

''Column not found'' Or
''Table not found'' Or

Application does''t returns any Records and some time returns records but not according to our searching criteria.

Regards
Arvind

答

嗨
我们也面临着同样的问题.

以下是有助于解决问题的命令.
在我们的例子中，第一个命令解决了这个问题.

ALTER DATABASE<数据库名称>
SET READ_COMMITTED_SNAPSHOT ON;

ALTER DATABASE<数据库名称>
设置ALLOW_SNAPSHOT_ISOLATION ON;

注意:
1.在执行之前，请先阅读/研究MSDN中的两个命令
2.确保在触发命令时不使用数据库.

Hi
we also faced the same problem.

Below are the commands that helped to solve the problem.
In our case the first command solved the problem.

ALTER DATABASE <Database Name>
SET READ_COMMITTED_SNAPSHOT ON;

ALTER DATABASE <Database Name>
SET ALLOW_SNAPSHOT_ISOLATION ON;

Note:
1. Do read/study the both commands in MSDN before execution
2. Make sure, your database should not be in use when you fire the commands.

Asp.net性能问题

相关推荐