SAP MSQSNAP table - MS SQL Server: Database performance snapshot details in SAP


SAP MSQSNAP table summary

Object Name: MSQSNAP
Dictionary Type: Transparent table
Description: MS SQL Server: Database performance snapshot


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

Details
MSQSNAP-RECORDDATE table field - Date

Description: Date
Field Name: RECORDDATE
Data Element: DATUM
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RECORDDATE

MSQSNAP-RECORDTIME table field - Time

Description: Time
Field Name: RECORDTIME
Data Element: UZEIT
Data Type: TIMS
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: UZEIT
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RECORDTIME

MSQSNAP-ELAPSEDSEC table field - MS SQL Server number of seconds elapsed since DB startup

Description: MS SQL Server number of seconds elapsed since DB startup
Field Name: ELAPSEDSEC
Data Element: MSSELAPSED
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 ELAPSEDSEC

MSQSNAP-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: 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

MSQSNAP-SQLVERSION table field - Version of the database management system.

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

MSQSNAP-SQLBUILDNM table field - SQL Server build number (corresponding to a Service Pack).

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

MSQSNAP-PRODLEVEL table field - Date the executable sqlservr.exe was created.

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

MSQSNAP-SQLSTARTTM table field - Date and time of last SQL Server start.

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

MSQSNAP-SQLEE table field - SQL Server edition: 'X' = Enterprise Ed., 'C' Cluster in use

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

MSQSNAP-NTVER table field - OS edition: A=Advanced Server, S=Server, D=Datacenter.

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

MSQSNAP-PARAMDIFF table field - Single-Character Flag

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

MSQSNAP-DISKPERF table field - Single-Character Flag

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

MSQSNAP-ISCLUSTER table field - Is SQL Server clustered 'Y' or 'N'

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

MSQSNAP-IS3GB table field - Is SQL Server on machine with /3GB switch on 'Y' or 'N'

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

MSQSNAP-ISPAE table field - Is SQL Server on machine with PAE 'Y' or 'N'

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

MSQSNAP-ISAWE table field - Is SQL Server AWE enabled Y' or 'N'

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

MSQSNAP-CHIP table field - Processor type being used on the host running SQL Server.

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

MSQSNAP-WINVER table field - Operating system version running on SQL Server host.

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

MSQSNAP-NUMCPUS table field - Number of CPUs on the host which runs SQL Server.

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

MSQSNAP-SQLCPUS table field - Maximum number of CPUs SQL Server is configured to use.

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

MSQSNAP-MASK table field - Bitmask representing the CPUs available to Windows.

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

MSQSNAP-PHYMEM table field - Amount of RAM on the server running SQL Server

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

MSQSNAP-TRACEFLAGS table field - Trace flags which are currently set for SQL Server.

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

MSQSNAP-MEMSETTING table field - Specifies how SQL Server memory parameters have been set

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

MSQSNAP-AGTLOGLOC table field - UNC path to a file used by SQL Server

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

MSQSNAP-ERRLOGLOC table field - UNC path to a file used by SQL Server

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

MSQSNAP-CONNECTMEM table field - Amount of dynamic memory the server is using for connections

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

MSQSNAP-WRKPROCMEM table field - Amount of memory granted to executing processes in KB

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

MSQSNAP-LOCKMEMORY table field - Amount of dynamic memory used for locks in KB

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

MSQSNAP-MAXWSPMEM table field - Maximum amount of memory available for executing SQL process

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

MSQSNAP-OPTQRYMEM table field - Amount of memory SQL Server is using for query optimization

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

MSQSNAP-SQLCACMEM table field - Amount of memory being used for dynamic SQL cache in KB

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

MSQSNAP-TARSRVMEM table field - Amount of memory SQL Server is willing to consume in KB

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

MSQSNAP-TTLSRVMEM table field - Amount of memory SQL Server is currently using in KB.

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

MSQSNAP-USERCONCTS table field - Number of user connections to the SQL Server system

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

MSQSNAP-CACHEHIT table field - Percentage of pages found in the buffer cache

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

MSQSNAP-DATACACHSZ table field - Size in KB of the data cache, including unused space

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

MSQSNAP-CACHESIZE table field - Size in KB of the procedure cache, including unused space.

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

MSQSNAP-BUFFCOMMIT table field - Number of committed pages in cache.

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

MSQSNAP-FREEBUFFER table field - Number of free pages available in cache.

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

MSQSNAP-STLPAGECNT table field - Number of buffer pages taken for other memory requirements

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

MSQSNAP-FULLSCANS table field - Number of unrestricted base table or index scans

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

MSQSNAP-INDEXSRCH table field - Number of index searches

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

MSQSNAP-EXTALLOCS table field - Number of extents allocated to database objects

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

MSQSNAP-EXTDEALLS table field - Number of extents deallocated in a database

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

MSQSNAP-PAGEALLOCS table field - Number of pages allocated to database objects

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

MSQSNAP-PAGEDEALLS table field - Number of pages deallocated in a database

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

MSQSNAP-PAGESPLITS table field - Number of index page splits in a database

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

MSQSNAP-PROBESCANS table field - Number of probe scans in a database

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

MSQSNAP-RANGESCANS table field - Number of range scans through indexes

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

MSQSNAP-WORKFILES table field - Number of work files created

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

MSQSNAP-WORKTABLES table field - Number of work tables created

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

MSQSNAP-LAZYWRITES table field - Number of pages written by the lazy writer to disk.

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

MSQSNAP-PAGEREADS table field - Number of physical page reads

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

MSQSNAP-PAGEWRITES table field - Number of physical page writes

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

MSQSNAP-REQBUFFPG table field - Number of requests to find a page in the buffer pool.

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

MSQSNAP-READAHEAD table field - Number of pages read in anticipation of use.

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

MSQSNAP-AUTOPARAM table field - Number of auto-parameterization attempts

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

MSQSNAP-SQLBATCHS table field - Number of SQL batch requests received by server.

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

MSQSNAP-SQLCOMPILE table field - Number of SQL compilations

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

MSQSNAP-AVGLTCHWT table field - Average wait time in ms for latch requests that waited.

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

MSQSNAP-LATCHWAITS table field - Number of latch requests that had to wait before granted.

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

MSQSNAP-DB_SIZE table field - Database size in MB

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

MSQSNAP-DB_ALLOC table field - Allocated space in database in MB

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

MSQSNAP-LOG_SIZE table field - Log size in MB

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

MSQSNAP-LOG_ALLOC table field - Allocated space in log in MB

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

MSQSNAP-RESERVED table field - Reserved size in KB

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

MSQSNAP-NUMTABS table field - Number of user tables

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

MSQSNAP-TABDATA table field - Data size in KB

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

MSQSNAP-NUMINDS table field - Number of indexes of user tables

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

MSQSNAP-INDDATA table field - Index size in KB

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

MSQSNAP-UNUSED table field - Unused size in KB

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

MSQSNAP-NUMPROCS table field - Number of stored procedures created in DBI

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

MSQSNAP-SQLUPTIME table field - Number of seconds SQL Server has been running.

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

MSQSNAP-CPUBUSY table field - Number of seconds CPUs have been busy (sum for all CPUs) .

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

MSQSNAP-CPUIDLE table field - Number of seconds CPUs have been idle (sum for all CPUs) .

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

MSQSNAP-IOBUSY table field - Number of seconds SQL Server tasks were busy with IO.

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

MSQSNAP-PCTCPU table field - Percent of time the CPUs have been busy.

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

MSQSNAP-PCTIDLE table field - Percent of time CPUs have been idle.

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

MSQSNAP-PCTIO table field - Percent of time SQL Server tasks have beeen busy whit IO.

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

MSQSNAP-PACKRECD table field - Number of network packets received.

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

MSQSNAP-PACKSENT table field - Number of network packets sent out by SQL Server.

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

MSQSNAP-CONNECTS table field - Number of attempted connections to SQL Server.

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

MSQSNAP-PACKERRORS table field - Number of network packets with error since SQL Server start.

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

MSQSNAP-TOTALREAD table field - Number of disk reads done by SQL Server (physical reads).

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

MSQSNAP-TOTALWRITE table field - Number of physical disk writes done by SQL Server.

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

MSQSNAP-TOTALERROR table field - Number of disk read or write errors since SQL Server started

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

MSQSNAP-CACHETYPE table field - Type of object in SQL Server procedure cache.

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

MSQSNAP-HITRATIO table field - Procedure cache hit ratio as percentage.

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

MSQSNAP-OBJECTCNT table field - Number of objects stored in the procedure cache.

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

MSQSNAP-OBJPAGES table field - Number of pages used by this object type in the cache.

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

MSQSNAP-USECOUNTS table field - Number of times an object of this type has been used.

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

MSQSNAP-R3USERS table field - Number of connections to SAP database from SAP application.

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

MSQSNAP-OTHERUSER table field - Number of non-SAP processes connected to SAP database.

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

MSQSNAP-UNIUSER table field - Number of different users connected to SAP database

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


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table