SAP ABAP Table MSS_SESSION (/sys.dm_exec_sessions structure from SQL Server 9.0)
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
Table Category INTTAB    Structure 
Structure MSS_SESSION   Table Relationship Diagram
Short Description /sys.dm_exec_sessions structure from SQL Server 9.0    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 SESSIONID MSSSESSIONID MSSINT4 INT4 10   0   Session ID for SQL Server  
2 LOGINTIME MSQPRLGTME CHAR24 CHAR 24   0   The time at which client process logged into SQL Server.  
3 HOSTNAME MSQHOSTNE CHAR128 CHAR 128   0   Hostname of the application server logged into SQL Server.  
4 PROGNAME MSQAPPPROG CHAR256 CHAR 256   0   Name of the application program which owns the connection.  
5 HOSTPID MSSHPID MSSINT4 INT4 10   0   Process ID on app. server  
6 CLIENTINFVER MSSSESSINTFVER   INT4 10   0   MSS Session client interface name  
7 CLIENTINFNAME MSSSESSINTFNAME CHAR64 CHAR 64   0   MSS Session client interface name  
8 LOGINNAME MSQUSRNAME CHAR128 CHAR 128   0   The user name used to log into the SQL Server database  
9 NTDOMAIN MSQNTDOMA CHAR256 CHAR 256   0   NT domain for the client connected to SQL Server.  
10 NTUNAME MSQNTUNAME CHAR256 CHAR 256   0   Windows NT user name for the process connected to SQL Server  
11 CPUTIME MSSSESCPUTIME INT4 INT4 10   0   CPU time for a SQL session (ms)  
12 MEMUSAGE MSQPRMEMUS INT4 INT4 10   0   The pages allocated by the SQL process in procedure cache.  
13 TTLSCHEDTIME MSSESSCHTIME   INT4 10   0   SQL Server session scheduled time  
14 TTLELAPSEDTIME MSSESSELPTIME   INT4 10   0   SQL Server session elapsed time  
15 SESS_NUMREADS MSSSESNUMREADS MSQBIGINT DEC 20   0   number of reads performed in a session  
16 SESS_NUMWRITES MSSSESNUMWRITES MSQBIGINT DEC 20   0   Number of writes performed in a session  
17 SESS_NUMLOGICALREADS MSSSESNUMLOGRDS MSQBIGINT DEC 20   0   number of reads performed by a session  
18 TRXISOLEVEL MSSTRXISOLEVEL   CHAR 12   0   MSS Transaction Isolation level  
History
Last changed by/on SAP  20110908 
SAP Release Created in 700