Determines which sessions the SAP ASE server is tracing. Returns the server process IDs (spids) for all the sessions the SAP ASE server is tracing, the spids of the sessions tracing them, and the name of the tracefile.
sp_helpapptrace
sp_helpapptrace
traced_spid tracer_spid trace_file ------------- ------------ ---------- 11 exited /tmp/myfile1 13 14 /tpcc/sybase.15_0/myfile2
traced_spid – spid of the session you are tracing.
tracer_spid – spid of the session that traced_spid is tracing. Prints “exited” if the tracer_spid session has exited.
trace_file – full path to the tracefile.
If a session is tracing another session, but quits without disabling the tracing, the SAP ASE server allows a new session to rebind with the earlier trace. This means that a sa or sso is not required to finish every trace they start, but can start a trace session, quit, and then rebind to this trace session
The permission checks for sp_helpapptrace differ based on your granular permissions settings.
| Setting | Description |
|---|---|
Enabled | With granular permissions enabled, you must be a user with manage server privilege. |
Disabled | With granular permissions disabled, you must be a user with sa_role or sso_role. |