SAP MSSST04LST table - MS SQL Server: ST04 Main Screen Display Structure details in SAP

Description: Hostname of the application server logged into SQL Server
Field Name: HOSTNAME
Data Element: MSSHOSTNM_
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: TEXT30
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOSTNAME

Description: Version of the database management system.
Field Name: SQLVERSION
Data Element: MSQVERSN
Data Type: CHAR
length (Dec): 50(0)
Check table:
Conversion Routine:
Domain Name: CHAR50
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLVERSION

Description: SQL Server build number (corresponding to a Service Pack).
Field Name: SQLBUILDNM
Data Element: MSQDBVER
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 SQLBUILDNM

Description: Date the executable sqlservr.exe was created.
Field Name: PRODLEVEL
Data Element: MSQSSBLDDT
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 PRODLEVEL

Description: Date and time of last SQL Server start.
Field Name: SQLSTARTTM
Data Element: MSQDBUPTME
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: CHAR20
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLSTARTTM

Description: SQL Server edition: 'X' = Enterprise Ed., 'C' Cluster in use
Field Name: SQLEE
Data Element: MSQSSSQLEE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLEE

Description: OS edition: A=Advanced Server, S=Server, D=Datacenter.
Field Name: NTVER
Data Element: MSQSSNTEE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NTVER

Description: Single-Character Flag
Field Name: PARAMDIFF
Data Element: CHAR1
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARAMDIFF

Description: Single-Character Flag
Field Name: DISKPERF
Data Element: CHAR1
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DISKPERF

Description: Is SQL Server clustered 'Y' or 'N'
Field Name: ISCLUSTER
Data Element: MSSISCLUSTER
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ISCLUSTER

Description: Is SQL Server on machine with /3GB switch on 'Y' or 'N'
Field Name: IS3GB
Data Element: MSSIS3GB
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field IS3GB

Description: Is SQL Server on machine with PAE 'Y' or 'N'
Field Name: ISPAE
Data Element: MSSISPAE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ISPAE

Description: Is SQL Server AWE enabled Y' or 'N'
Field Name: ISAWE
Data Element: MSSISAWE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ISAWE

Description: Processor type being used on the host running SQL Server.
Field Name: CHIP
Data Element: MSQSSCHIP
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: CHAR20
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CHIP

Description: Operating system version running on SQL Server host.
Field Name: WINVER
Data Element: MSQSSWVER
Data Type: CHAR
length (Dec): 80(0)
Check table:
Conversion Routine:
Domain Name: CHAR80
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WINVER

Description: Number of CPUs on the host which runs SQL Server.
Field Name: NUMCPUS
Data Element: MSQSSCPUS
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 NUMCPUS

Description: Maximum number of CPUs SQL Server is configured to use.
Field Name: SQLCPUS
Data Element: MSQSQLCPUS
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 SQLCPUS

Description: Bitmask representing the CPUs available to Windows.
Field Name: MASK
Data Element: MSQSSMASK
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: CHAR08
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MASK

Description: Amount of RAM on the server running SQL Server
Field Name: PHYMEM
Data Element: MSQSSRAM
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 PHYMEM

Description: Trace flags which are currently set for SQL Server.
Field Name: TRACEFLAGS
Data Element: MSQSSTFLG
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 TRACEFLAGS

Description: Specifies how SQL Server memory parameters have been set
Field Name: MEMSETTING
Data Element: MSQMEMSET
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR010
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MEMSETTING

Description: UNC path to a file used by SQL Server
Field Name: AGTLOGLOC
Data Element: MSSPATH
Data Type: CHAR
length (Dec): 255(0)
Check table:
Conversion Routine:
Domain Name: MSSCSC255
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AGTLOGLOC

Description: UNC path to a file used by SQL Server
Field Name: ERRLOGLOC
Data Element: MSSPATH
Data Type: CHAR
length (Dec): 255(0)
Check table:
Conversion Routine:
Domain Name: MSSCSC255
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ERRLOGLOC

Description: Amount of dynamic memory the server is using for connections
Field Name: CONNECTMEM
Data Element: MSSPMCONN
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONNECTMEM

Description: Amount of memory granted to executing processes in KB
Field Name: WRKPROCMEM
Data Element: MSSPMGWSPM
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WRKPROCMEM

Description: Amount of dynamic memory used for locks in KB
Field Name: LOCKMEMORY
Data Element: MSSPMLCKM
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOCKMEMORY

Description: Maximum amount of memory available for executing SQL process
Field Name: MAXWSPMEM
Data Element: MSSPMMWSPM
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MAXWSPMEM

Description: Amount of memory SQL Server is using for query optimization
Field Name: OPTQRYMEM
Data Element: MSSPMOPMEM
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OPTQRYMEM

Description: Amount of memory being used for dynamic SQL cache in KB
Field Name: SQLCACMEM
Data Element: MSSPMCACM
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLCACMEM

Description: Amount of memory SQL Server is willing to consume in KB
Field Name: TARSRVMEM
Data Element: MSSPMTARSM
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TARSRVMEM

Description: Amount of memory SQL Server is currently using in KB.
Field Name: TTLSRVMEM
Data Element: MSSPMTTLSM
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TTLSRVMEM

Description: Number of user connections to the SQL Server system
Field Name: USERCONCTS
Data Element: MSSPSUSCON
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USERCONCTS

Description: Percentage of pages found in the buffer cache
Field Name: CACHEHIT
Data Element: MSSPBCACHT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CACHEHIT

Description: Size in KB of the data cache, including unused space
Field Name: DATACACHSZ
Data Element: MSSPBDATAC
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DATACACHSZ

Description: Size in KB of the procedure cache, including unused space.
Field Name: CACHESIZE
Data Element: MSSPBCACSZ
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CACHESIZE

Description: Number of committed pages in cache.
Field Name: BUFFCOMMIT
Data Element: MSSPBCOMIT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BUFFCOMMIT

Description: Number of free pages available in cache.
Field Name: FREEBUFFER
Data Element: MSSPBFREBF
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FREEBUFFER

Description: Number of buffer pages taken for other memory requirements
Field Name: STLPAGECNT
Data Element: MSSPBSTPCT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STLPAGECNT

Description: Number of unrestricted base table or index scans
Field Name: FULLSCANS
Data Element: MSSPAFULLS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FULLSCANS

Description: Number of index searches
Field Name: INDEXSRCH
Data Element: MSSPAIDXSR
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INDEXSRCH

Description: Number of extents allocated to database objects
Field Name: EXTALLOCS
Data Element: MSSPAEXAL
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXTALLOCS

Description: Number of extents deallocated in a database
Field Name: EXTDEALLS
Data Element: MSSPAEXDE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXTDEALLS

Description: Number of pages allocated to database objects
Field Name: PAGEALLOCS
Data Element: MSSPAPGAL
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PAGEALLOCS

Description: Number of pages deallocated in a database
Field Name: PAGEDEALLS
Data Element: MSSPAPGDE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PAGEDEALLS

Description: Number of index page splits in a database
Field Name: PAGESPLITS
Data Element: MSSPAPGSPL
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PAGESPLITS

Description: Number of probe scans in a database
Field Name: PROBESCANS
Data Element: MSSPAPRBSN
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PROBESCANS

Description: Number of range scans through indexes
Field Name: RANGESCANS
Data Element: MSSPARNGSN
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RANGESCANS

Description: Number of work files created
Field Name: WORKFILES
Data Element: MSSPAWFCRE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WORKFILES

Description: Number of work tables created
Field Name: WORKTABLES
Data Element: MSSPAWTCRE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WORKTABLES

Description: Number of pages written by the lazy writer to disk.
Field Name: LAZYWRITES
Data Element: MSSPBLZWTS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LAZYWRITES

Description: Number of physical page reads
Field Name: PAGEREADS
Data Element: MSSPBPGRDS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PAGEREADS

Description: Number of physical page writes
Field Name: PAGEWRITES
Data Element: MSSPBPGWRT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PAGEWRITES

Description: Number of requests to find a page in the buffer pool.
Field Name: REQBUFFPG
Data Element: MSSPBUFREQ
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REQBUFFPG

Description: Number of pages read in anticipation of use.
Field Name: READAHEAD
Data Element: MSSPBRAPGS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field READAHEAD

Description: Number of auto-parameterization attempts
Field Name: AUTOPARAM
Data Element: MSSPSAUTO
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AUTOPARAM

Description: Number of SQL batch requests received by server.
Field Name: SQLBATCHS
Data Element: MSSPSBATCH
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLBATCHS

Description: Number of SQL compilations
Field Name: SQLCOMPILE
Data Element: MSSPSQLCMP
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLCOMPILE

Description: Average wait time in ms for latch requests that waited.
Field Name: AVGLTCHWT
Data Element: MSSPSALTWT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AVGLTCHWT

Description: Number of latch requests that had to wait before granted.
Field Name: LATCHWAITS
Data Element: MSSPSLTHWT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LATCHWAITS

Description: Database size in MB
Field Name: DB_SIZE
Data Element: MSS_DBSIZE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DB_SIZE

Description: Allocated space in database in MB
Field Name: DB_ALLOC
Data Element: MSS_DBALLOC
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DB_ALLOC

Description: Log size in MB
Field Name: LOG_SIZE
Data Element: MSS_LOGSIZE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOG_SIZE

Description: Allocated space in log in MB
Field Name: LOG_ALLOC
Data Element: MSS_LOGALLOC
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOG_ALLOC

Description: Reserved size in KB
Field Name: RESERVED
Data Element: MSSRESSIZE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RESERVED

Description: Number of user tables
Field Name: NUMTABS
Data Element: MSSNUMTABLES
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NUMTABS

Description: Data size in KB
Field Name: TABDATA
Data Element: MSSDATASIZE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TABDATA

Description: Number of indexes of user tables
Field Name: NUMINDS
Data Element: MSSNUMINDEXES
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NUMINDS

Description: Index size in KB
Field Name: INDDATA
Data Element: MSSINDEXSIZE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INDDATA

Description: Unused size in KB
Field Name: UNUSED
Data Element: MSSUNUSEDSIZE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field UNUSED

Description: Number of stored procedures created in DBI
Field Name: NUMPROCS
Data Element: MSSNUMPROCS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NUMPROCS

Description: Number of seconds SQL Server has been running.
Field Name: SQLUPTIME
Data Element: MSQDSSQLSC
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 SQLUPTIME

Description: Number of seconds CPUs have been busy (sum for all CPUs) .
Field Name: CPUBUSY
Data Element: MSQDSCPUBY
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 CPUBUSY

Description: Number of seconds CPUs have been idle (sum for all CPUs) .
Field Name: CPUIDLE
Data Element: MSQDSCPUID
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 CPUIDLE

Description: Number of seconds SQL Server tasks were busy with IO.
Field Name: IOBUSY
Data Element: MSQDSIOBSY
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 IOBUSY

Description: Percent of time the CPUs have been busy.
Field Name: PCTCPU
Data Element: MSQDSCPPCT
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 PCTCPU

Description: Percent of time CPUs have been idle.
Field Name: PCTIDLE
Data Element: MSQDSIDPCT
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 PCTIDLE

Description: Percent of time SQL Server tasks have beeen busy whit IO.
Field Name: PCTIO
Data Element: MSQDSIOPCT
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 PCTIO

Description: Number of network packets received.
Field Name: PACKRECD
Data Element: MSQDSPCKRD
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 PACKRECD

Description: Number of network packets sent out by SQL Server.
Field Name: PACKSENT
Data Element: MSQDSPCKST
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 PACKSENT

Description: Number of attempted connections to SQL Server.
Field Name: CONNECTS
Data Element: MSQDSCONN
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 CONNECTS

Description: Number of network packets with error since SQL Server start.
Field Name: PACKERRORS
Data Element: MSQDSPCKER
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 PACKERRORS

Description: Number of disk reads done by SQL Server (physical reads).
Field Name: TOTALREAD
Data Element: MSQDSTOTRD
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 TOTALREAD

Description: Number of physical disk writes done by SQL Server.
Field Name: TOTALWRITE
Data Element: MSQDSTOTWR
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 TOTALWRITE

Description: Number of disk read or write errors since SQL Server started
Field Name: TOTALERROR
Data Element: MSQDSTOTER
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 TOTALERROR

Description: Type of object in SQL Server procedure cache.
Field Name: CACHETYPE
Data Element: MSSPCTYPE
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: CHAR40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CACHETYPE

Description: Procedure cache hit ratio as percentage.
Field Name: HITRATIO
Data Element: MSSPCRATIO
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HITRATIO

Description: Number of objects stored in the procedure cache.
Field Name: OBJECTCNT
Data Element: MSSPCOBJCT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OBJECTCNT

Description: Number of pages used by this object type in the cache.
Field Name: OBJPAGES
Data Element: MSSPCPAGES
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OBJPAGES

Description: Number of times an object of this type has been used.
Field Name: USECOUNTS
Data Element: MSSPCUSECT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USECOUNTS

Description: Number of connections to SAP database from SAP application.
Field Name: R3USERS
Data Element: MSQDBSAPPC
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 R3USERS

Description: Number of non-SAP processes connected to SAP database.
Field Name: OTHERUSER
Data Element: MSQDBNUMPC
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 OTHERUSER

Description: Number of different users connected to SAP database
Field Name: UNIUSER
Data Element: MSQDBNDUSR
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 UNIUSER