Click here to Skip to main content
14,827,050 members
Please Sign up or sign in to vote.
3.67/5 (3 votes)
See more:
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
Posted

1 solution

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.
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900