Information Returned (sp

A summary of information returned by sp_ps.

Type of Information	Meaning
SPID	The internal thread number of the thread.
Login Name	The name of the logged in user. Applies only to client threads.
Host Name	For a client task, this is the name of the client’s machine. For site handlers and server-to-server RPC connections, this is the name of the remote Adaptive Server.
Program Name	The name of the client application program.
Task Type	The type of thread. The legal values are: NETWORK CLIENT SERVER SITE HANDLER CHILD SERVICE UNKNOWN
Status	The current status of the thread. The legal values for this column are: RUNNING RUNNABLE SLEEPING SICK FREE STOPPED SPAWNED TERMINAL UNKNOWN The one “running” task is the thread that is executing sp_ps.
Sleep Event	The event that causes a sleeping thread to run.
Sleep Label	A character string label that describes the sleep event.
Current Command	A character string that describes the state of the thread. The contents of this column are set by the srv_thread_props routine.
Blocked By	(Not currently used.)
Run Ticks	(Not currently used.)
Current Priority	The priority at which the thread is running.
Stack Origin	The address in memory where the thread’s stack begins.
Net Writes	The number of network writes since the thread started. This number applies only to site handler and client threads.
Net Reads	The number of network reads since the thread started. This number applies only to site handler and client threads.

Information Returned (sp_ps)