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 | MSSPRGNAME |
| Short Description | Name of the application program which owns the connection |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | TEXT30 | |
| Data Type | CHAR | Character String |
| Length | 30 | |
| Decimal Places | 0 | |
| Output Length | 30 | |
| 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 | Applicat. |
| Medium | 15 | Application |
| Long | 20 | Application program |
| Heading | 30 | Application program |
Documentation
Definition
Each SQL Server process can have a program name that identifies the program using that database process.
Each SAP work process uses several SQL Server processes as database connections with the following program names:
R3xyy(0)comm rd committed read used for all updates/inserts
R3xyy(1)sp crea used to create stored procedures
R3xyy(2)sgl sel uncommitted read used for select single
R3xyy(zz)unc rd uncommitted read used for all reading selects
where x in (D,B,U,E,S) shows the type of work process
yy in (00..99) shows the number of the work process
zz in (00..99) shows number of connection (usually 00-07)
Other known non-SAP program names are:
MS SQLEW SQL Server enterprise manager
Microsoft ISQL/w interactive SQL query program
SQL PerfMon SQL Server performance monitor
History
| Last changed by/on | SAP | 20110908 |
| SAP Release Created in |
