Hi,
I have a .net 2 website running that from time to time with have all membership calls result in a db timeout:
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
All other sections of the site that run off the same db continue to run without issue. I think it must have something to do with certain tables getting locked.
I have tried adding in this statement to the membership stored procs that I read from somewhere else helps reduce the locks:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
I also tried looking at the Activity Monitor and killing processes in there which did not make a difference.
It happens on both our dev and live site so I'm not if traffic is the issue. It actually seems to happen usually after a period of inactivity.
Sometimes, it seems to work itself out but the only way I have been able to fix it is to take the db offline and t ...
Go to the complete details ...