SAP MSSSNAPHIS table - MS SQL Server MSQSNAP table history list details in SAP


SAP MSSSNAPHIS table summary

Object Name: MSSSNAPHIS
Dictionary Type: Structure
Description: MS SQL Server MSQSNAP table history list


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

Details
MSSSNAPHIS-WEEK table field - Factory calendar: Week

Description: Factory calendar: Week
Field Name: WEEK
Data Element: KWEEK
Data Type: ACCP
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: KWEEK
MemoryID:
AppClass: SCAL
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WEEK

MSSSNAPHIS-DAYOW table field - Day (for Collector)

Description: Day (for Collector)
Field Name: DAYOW
Data Element: DAYOFWEEK
Data Type: CHAR
length (Dec): 7(0)
Check table:
Conversion Routine:
Domain Name: CHAR7
MemoryID:
AppClass: SDIN
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DAYOW

MSSSNAPHIS-RECORDS table field - MS SQL Server peformance server: number of records

Description: MS SQL Server peformance server: number of records
Field Name: RECORDS
Data Element: MSSNUMRECD
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RECORDS

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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

MSSSNAPHIS-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