Welcome to the new platform of Programmers Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use it's exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
Database locking after some transactions for some reasons but can not
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,