SAP ABAP Data Element MSSSPIDTXT (MS SQL Server process ID)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-MSS (Application Component) Microsoft SQL Server
     ⤷ STUN_MSS (Package) Package for new SQL Server monitoring objects

Basic Data

Data Element	MSSSPIDTXT
Short Description	MS SQL Server process ID

Data Type

Category of Dictionary Type	D	Domain
Type of Object Referenced		No Information
Domain / Name of Reference Type	CHAR20
Data Type	CHAR	Character String
Length	20
Decimal Places	0
Output Length	20
Value Table

Further Characteristics

Search Help: Name
Search Help: Parameters
Parameter ID
Default Component name
Change document	☐
No Input History	☐
Basic direction is set to LTR	☐
No BIDI Filtering	☐

Field Label

	Length	Field Label
Short	10	SPID
Medium	14	SPID
Long	24	SQL Server process ID
Heading	30	SQL Server process ID

Documentation

Definition

Basic unit for concurrent activity in the SQL Server database system.
Each SQL Server process usually uses a separate NT thread for execution. Each SAP work process is connected to several SQL Server processes, which are also called "connections".
The process IDs are written in tree form, which shows the waiting situation. Since space is limited, only 5 levels can be shown, and all processes with a higher level are also shown as level 5. In the following example, processes 26 and 134 are waiting for process 17, while process 345 is waiting for process 26.
17
26
345
134

History

Last changed by/on	SAP	20110908
SAP Release Created in