We recently had an issue on a Window 2003 server that would seem to hang just on one secession, but not always the same secession. It was not on any specific program, file, subsystem, just completely random. What we, think, we found is that it had recently been added to an additional domain and it seemed that the excess time was being taken by authenticating over the internet to that new domain. When we took it off of that domain the hangs stopped. Our hangs were more like 15,30, 60 second hangs, not minutes that I am aware of.
HTH Tom Dodds -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Geoffrey Mitchell Sent: Friday, August 01, 2008 11:34 AM To: U2 Users List Subject: [U2] Help diagnosing mysterious database "hangs" (UV 10.1.25, HP-UX 11.11) We are experiencing periodic "hangs" (up to 5 minutes in duration) accessing the UV database. These hangs are manifesting when accessing the database through JDBC, sometimes when calling a stored procedure, sometimes when running queries directly through JDBC. The problem has appeared in two different, unrelated sub-systems (no common tables are accessed by both). Of course, we first suspected locking issues, but we have not been able to find any evidence that this is the case. In most cases, only one process seems to be accessing the table(s) in question at the time of the problem. Any ideas on how to go about diagnosing this? Or thoughts as to what might be the problem? It would be awfully nice to have a log of all of the queries being executed and how long they took, such as you can easily get from other databases, like mysql, or PostGresql..... -- Geoffrey Mitchell Programmer/Analyst Home Decorator's Collection 314-684-1062 ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __________ Information from ESET NOD32 Antivirus, version of virus signature database 3317 (20080801) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/