SAP MSS_SESSION table - /sys.dm_exec_sessions structure from SQL Server 9.0 details in SAP

Description: Session ID for SQL Server
Field Name: SESSIONID
Data Element: MSSSESSIONID
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: MSSINT4
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SESSIONID

Description: The time at which client process logged into SQL Server.
Field Name: LOGINTIME
Data Element: MSQPRLGTME
Data Type: CHAR
length (Dec): 24(0)
Check table:
Conversion Routine:
Domain Name: CHAR24
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOGINTIME

Description: Hostname of the application server logged into SQL Server.
Field Name: HOSTNAME
Data Element: MSQHOSTNE
Data Type: CHAR
length (Dec): 128(0)
Check table:
Conversion Routine:
Domain Name: CHAR128
MemoryID:
AppClass: SPO
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOSTNAME

Description: Name of the application program which owns the connection.
Field Name: PROGNAME
Data Element: MSQAPPPROG
Data Type: CHAR
length (Dec): 256(0)
Check table:
Conversion Routine:
Domain Name: CHAR256
MemoryID:
AppClass: SYST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PROGNAME

Description: Process ID on app. server
Field Name: HOSTPID
Data Element: MSSHPID
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: MSSINT4
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOSTPID

Description: MSS Session client interface name
Field Name: CLIENTINFVER
Data Element: MSSSESSINTFVER
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CLIENTINFVER

Description: MSS Session client interface name
Field Name: CLIENTINFNAME
Data Element: MSSSESSINTFNAME
Data Type: CHAR
length (Dec): 64(0)
Check table:
Conversion Routine:
Domain Name: CHAR64
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CLIENTINFNAME

Description: The user name used to log into the SQL Server database
Field Name: LOGINNAME
Data Element: MSQUSRNAME
Data Type: CHAR
length (Dec): 128(0)
Check table:
Conversion Routine:
Domain Name: CHAR128
MemoryID:
AppClass: SPO
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOGINNAME

Description: NT domain for the client connected to SQL Server.
Field Name: NTDOMAIN
Data Element: MSQNTDOMA
Data Type: CHAR
length (Dec): 256(0)
Check table:
Conversion Routine:
Domain Name: CHAR256
MemoryID:
AppClass: SYST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NTDOMAIN

Description: Windows NT user name for the process connected to SQL Server
Field Name: NTUNAME
Data Element: MSQNTUNAME
Data Type: CHAR
length (Dec): 256(0)
Check table:
Conversion Routine:
Domain Name: CHAR256
MemoryID:
AppClass: SYST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NTUNAME

Description: CPU time for a SQL session (ms)
Field Name: CPUTIME
Data Element: MSSSESCPUTIME
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CPUTIME

Description: The pages allocated by the SQL process in procedure cache.
Field Name: MEMUSAGE
Data Element: MSQPRMEMUS
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MEMUSAGE

Description: SQL Server session scheduled time
Field Name: TTLSCHEDTIME
Data Element: MSSESSCHTIME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TTLSCHEDTIME

Description: SQL Server session elapsed time
Field Name: TTLELAPSEDTIME
Data Element: MSSESSELPTIME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TTLELAPSEDTIME

Description: number of reads performed in a session
Field Name: SESS_NUMREADS
Data Element: MSSSESNUMREADS
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: MSQBIGINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SESS_NUMREADS

Description: Number of writes performed in a session
Field Name: SESS_NUMWRITES
Data Element: MSSSESNUMWRITES
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: MSQBIGINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SESS_NUMWRITES

Description: number of reads performed by a session
Field Name: SESS_NUMLOGICALREADS
Data Element: MSSSESNUMLOGRDS
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: MSQBIGINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SESS_NUMLOGICALREADS

Description: MSS Transaction Isolation level
Field Name: TRXISOLEVEL
Data Element: MSSTRXISOLEVEL
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TRXISOLEVEL

Description: Original name used to login to SQL Server
Field Name: ORIGLOGINNAME
Data Element: MSSORIGUSRNAME
Data Type: CHAR
length (Dec): 128(0)
Check table:
Conversion Routine:
Domain Name: CHAR128
MemoryID:
AppClass: SPO
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ORIGLOGINNAME