I am facing a very big problem after the deployment of my web project. Actually all the pages are running fine initially. But since its a multiuser platform, when users are doing their part session after session, after a time period any single session suddenly stops working putting the whole database in a lock position. As a result all the users, including the admin and the normal users are forced to stop working. Until and unless we are restarting the sql server, its not working for certain time period, say, 20 mins. After that it again starts working and all the things working fine. I have tried to find every aspect to review it but failed to grab it. We have developed it in dot net framework 3.5 with sql server 2005 in windows XP platform. But we have hosted it in windows server 2008 R2 with sql server 2005.
Replies for the thread will be cordially accepted. Thanks in advance,