System locks frequently and people can't log in - times out
Adam Wilden Aug 3, 2011 3:24 AMHi Folks,
We are on 7.4.
Once or twice a day the whole system seems to freeze and people can't login via either WebAccess or Console (usually both).
We get a timeout error after a couple of minutes.
We've not seen this on previous versions.
Resetting IIS or the app pool clears the problem, as usually does waiting it out for 10 minutes...
We can't see anything obvious causing this - ram and cpu are fine on all servers at the time and other functions on the servers run fine.
Our DBAs have checked and the query using the most resources at the time is:
SELECT T1.tps_name,T1.tps_account_disabled,T1.tps_guid,T1.tps_title,T1.tps_deleted,T1.tps_user_type_guid
FROM tps_user T1
WHERE (T1.tps_name=:0) AND T1.tps_deleted=:1
which I assume is the main user lookup?
We've patched for problem 5154 which we had hoped would cure this but we are still seeing it the freeze regularly.
Anyone else seen this?
Are there any diagnostic tools, logging we can use to get moe info?
Thanks - Adam.