To enable StoreHouse 5 logging:
- Open the registry editor and go to HKLM\Software\USC\sdbserv.2\Server_key
- Create the DWORD uplt parameter — the maximum allowed procedure execution time in ms — with a value, for example, 100.
- Save your changes and restart the StoreHouse 5 server.
The log looks like this:
11.10.2019 14:30:10- PROCTIME DebugProc time=1.050 sec, conn_id=11, status=
How to read the log: procedure name is DebugProc, the execution time, including the commit or rollback time, is 1.05 seconds, the connection ID is 11, the procedure was completed successfully; the signature for the search is PROCTIME.