page99
81
try
{
retval = stmt.execute();
while(retval.next())
(
result = retval.getColumnValue(1)
)
}
catch(err)
{
err_state = sql_stmt;
err_state += "\nFail Code: " + err.code;
err_state += "\nState: " + err.state;
err_state += "\nMessage : " + err.message;
err_state += "\nStack Trace:\n" + err.StackTraceTxt;
result = err_state;
}
return result;
$$;
To call
sp_test_bind
, use the following
CALL
statement:
CALL sp_test_bind( 'Andrew Carruthers' );
Long compilation time monitoring for trends is worth considering as this metric
may be a leading indicator of future performance issues. This metric can provide early
warning of data skewing.
Long Execution Time
Long execution time is typically a trend-based metric where progressive or sudden
adverse changes in either a single query or several queries may be observed. Monitoring
long execution time may be a leading indicator of future performance issues.
ChapTer 3
The Query profiler