Database locking after some transactions for some reasons but can not find it after reviews

Question

0.00/5 (No votes)

See more:

Hi,

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. Untill 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,

Posted 16-Oct-12 0:39am

atanu123

Add a Solution

Comments

skydger 16-Oct-12 15:01pm

Have you tried to run SQL Server Profiler? How many transactions per minute it has?

atanu123 17-Oct-12 6:51am

Hi skydger
thanks for the reply. Actually i didn't know how to run the sql profiler. Actually we have developed a multi user application where any type of user can log-in at a time. so its very tough to tell how many transaction it does per minute in prime time but it does many.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

manak chand · Accepted Answer · 2012-10-17T01:03:00

Solution 2

If you are using reporting in webapplication. Please check for any procedure locking the main table which may be useful in multiple transactions and master forms..

Posted 17-Oct-12 1:03am

manak chand

Comments

atanu123 17-Oct-12 9:20am

Hi manak,
actually i have checked the stored procedures i have used. but can't find any procedure with infinite loops. its happening only when the users are working simultaneously.

manak chand 17-Oct-12 9:33am

Try for
>> pooling concept for database connections
>> Check for every opened database connection is closed