Since ESRI direction is with "direct connection" to the database instead of Application Server Connection.
Its Imperative to consolidate Log Files generated in the "server" (3-tier architecutre) to be included in ArcSDE System Tables.
The SDE Geodatabase Administrator should have a "centralized" log files repository for troubleshooting.
