C
ChUIMonster
Guest
Client logging with "4gl Trans" enabled would be great but it is very rare to find that it has been enabled for all clients in production. As Rob says CSC isn't perfect but it does often at least give you an idea where to start looking and you can enable it from the server side without the user needing to do anything. I might has missed it but proGetStack is also a useful tool if you have access to the command line on the machine that the client connects from. At a minimum just knowing the name of the guilty user is frequently a pretty good clue -- many times I have pointed out a long running transaction to an admin at a customer site and they immediately know what that user is running. And they often know what was changed that is probably causing the problem. Random thought: it would be really cool if the program name and statement line# that start a TRX was recorded automatically and available in _Trans 
Continue reading...
Continue reading...