SAP MSQ_PROCES table - Data on the processes connected SQL Server details in SAP


SAP MSQ_PROCES table summary

Object Name: MSQ_PROCES
Dictionary Type: Structure
Description: Data on the processes connected SQL Server


Field list for MSQ_PROCES table on an S/4 SAP system

Details
MSQ_PROCES-SPID table field - SQL Server process ID

Description: SQL Server process ID
Field Name: SPID
Data Element: MSQSERPRID
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 SPID

MSQ_PROCES-KPID table field - Windows operating system thread ID of SQL process

Description: Windows operating system thread ID of SQL process
Field Name: KPID
Data Element: MSQTHREADI
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 KPID

MSQ_PROCES-BLOCKED table field - The SPID of the process blocking this SQL process.

Description: The SPID of the process blocking this SQL process.
Field Name: BLOCKED
Data Element: MSQBLOCPRI
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 BLOCKED

MSQ_PROCES-WAITTYPE table field - The wait type of the waiting process.

Description: The wait type of the waiting process.
Field Name: WAITTYPE
Data Element: MSQWAITYPE
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 WAITTYPE

MSQ_PROCES-WAITTIME table field - Current wait time of the process in milliseconds

Description: Current wait time of the process in milliseconds
Field Name: WAITTIME
Data Element: MSQWAITIME
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 WAITTIME

MSQ_PROCES-SQLWAITRES table field - The last wait event the process had to wait for..

Description: The last wait event the process had to wait for..
Field Name: SQLWAITRES
Data Element: MSQWAITRES
Data Type: CHAR
length (Dec): 32(0)
Check table:
Conversion Routine:
Domain Name: CHAR32
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLWAITRES

MSQ_PROCES-SAPWAIT table field - Name of the locked resource the process is waiting for.

Description: Name of the locked resource the process is waiting for.
Field Name: SAPWAIT
Data Element: MSQSAPWAIT
Data Type: CHAR
length (Dec): 255(0)
Check table:
Conversion Routine:
Domain Name: CHAR255
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SAPWAIT

MSQ_PROCES-SQLWAIT table field - The locked resource process is waiting for (object ID).

Description: The locked resource process is waiting for (object ID).
Field Name: SQLWAIT
Data Element: MSQSQLWAIT
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 SQLWAIT

MSQ_PROCES-DBNAME table field - Database name

Description: Database name
Field Name: DBNAME
Data Element: MSSDB
Data Type: CHAR
length (Dec): 128(0)
Check table:
Conversion Routine:
Domain Name: MSSSYSNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBNAME

MSQ_PROCES-CPU table field - MS SQL Server total cumulative CPU time for a SQL process

Description: MS SQL Server total cumulative CPU time for a SQL process
Field Name: CPU
Data Element: MSQCPUTIME
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 CPU

MSQ_PROCES-PHYSIO table field - The total cumulative disk reads and writes for the process.

Description: The total cumulative disk reads and writes for the process.
Field Name: PHYSIO
Data Element: MSQPHYSIIO
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 PHYSIO

MSQ_PROCES-MEMUSAGE table field - The pages allocated by the SQL process in procedure cache.

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

MSQ_PROCES-LOGINTIME table field - The time at which client process logged into SQL Server.

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

MSQ_PROCES-LSTBATTIME table field - Last time a stor. proc. or EXEC was executed on SQL process.

Description: Last time a stor. proc. or EXEC was executed on SQL process.
Field Name: LSTBATTIME
Data Element: MSQLTBATTM
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 LSTBATTIME

MSQ_PROCES-ECID table field - Execution context ID used to uniquely identify subthreads

Description: Execution context ID used to uniquely identify subthreads
Field Name: ECID
Data Element: MSQPRCECID
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 ECID

MSQ_PROCES-OPENTRAN table field - Number of open transactions for the SQL Server process

Description: Number of open transactions for the SQL Server process
Field Name: OPENTRAN
Data Element: MSSOPENTRAN
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OPENTRAN

MSQ_PROCES-STATUS table field - SQL Server process status; ie sleeping, running etc.

Description: SQL Server process status; ie sleeping, running etc.
Field Name: STATUS
Data Element: MSQPROSTAT
Data Type: CHAR
length (Dec): 60(0)
Check table:
Conversion Routine:
Domain Name: CHAR60
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STATUS

MSQ_PROCES-LOGINNAME table field - The user name used to log into the SQL Server database

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

MSQ_PROCES-HOSTNAME table field - Hostname of the application server logged into SQL Server.

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

MSQ_PROCES-PROGNAME table field - Name of the application program which owns the connection.

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

MSQ_PROCES-HOSTPROS table field - The application program's process ID on the given host

Description: The application program's process ID on the given host
Field Name: HOSTPROS
Data Element: MSQWKPROID
Data Type: CHAR
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: CHAR16
MemoryID:
AppClass: SLG
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOSTPROS

MSQ_PROCES-EXECCMD table field - Command currently being executed by the given process id

Description: Command currently being executed by the given process id
Field Name: EXECCMD
Data Element: MSQEXECMD
Data Type: CHAR
length (Dec): 32(0)
Check table:
Conversion Routine:
Domain Name: CHAR32
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXECCMD

MSQ_PROCES-NTDOMAIN table field - NT domain for the client connected to SQL Server.

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

MSQ_PROCES-NTUNAME table field - Windows NT user name for the process connected to SQL Server

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

MSQ_PROCES-NETADD table field - Unique ID of the network interface of client (MAC address).

Description: Unique ID of the network interface of client (MAC address).
Field Name: NETADD
Data Element: MSQNETADDR
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: CHAR12
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NETADD

MSQ_PROCES-NETLIB table field - The network library the client is using.

Description: The network library the client is using.
Field Name: NETLIB
Data Element: MSQNETLIB
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: CHAR12
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NETLIB


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table