We have a web application which was running fine. Per day we expect nearly 5000 Rows in a table.
As the data grows , as the number of user grows, the system started throwing weird errors.
For example - It throws column user_id does not belong to the datatable. but the column does exist as per the coding. That datatable is getting structure and the data from the database.
Like this we get many runtime errors which are not actually errors.
As the users are internally sitting, if we ask all the users to close the web application and leave for few minutes, after some time it is starting to work normally. To rectify this problem we are doing the following processes temporarily.
- Restarting SQL server service
- Restarting IIS
- Close all the browsers
I presume the problem should be on the database connection or some other resource consumption. I'm closing, disposing all the connec ...
Go to the complete details ...