Execute Stored Procedure Trace Logging

Did you know, the execute stored procedure plug-in has a performance log? Each time a stored procedure is executed an entry is added to APPIAN_HOME/logs/perflogs/execute_stored_procedure_trace.csv
 
It contains a wide variety of metrics from connection time, execution time, data transformation time all the way through to the number of records the stored proc returns. This functionality has existed in the plug-in for a little over year (since v1.4.2)
 
The log is buffered before writing to disk, so overhead of logging every execution is minimal. This delays how frequently the log is written to disk. In v1.4.5 this will happen about once every 5 minutes.

  Discussion posts and replies are publicly visible