Unanswered: ASE 12.5.3 seems to freeze (latch sleep)
Hi guys, we have been experience some trouble at our installation since we migrate from ASE 11.5 to 12.5.3 six months ago. The problem is that ASE seems to freeze, and our application start to been blocked by some processes that have been reported "latch sleep" (sometimes we found some PLC sleep, but few). The execution turned very, VERY slow and obviously the cluster software thinks that the DB is down and starts a fail over procedure to the second node.
I saw a previous thread (ASE seems to hit a "brick wall" - Oct 2002) and Rob Verschoor indicates that this happens for no apparent reason (PLC sleep) and if you install a most recent EBF may the trouble disappear.
But now, 3 years later, we have some trouble similar to the one described in that thread.
Does anybody knows what it could be the problem?
Our installation is a Solaris 6, ASE 12.5.3, the databases are mounted on Solaris file systems (50dbs with over 1 TB) on a NetApp filer.