SAP ABAP Table MSSST04LST (MS SQL Server: ST04 Main Screen Display Structure)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-MSS (Application Component) Microsoft SQL Server
     ⤷ STUN_MSS (Package) Package for new SQL Server monitoring objects

Basic Data

Table Category	INTTAB	Structure
Structure	MSSST04LST	Table Relationship Diagram
Short Description	MS SQL Server: ST04 Main Screen Display Structure

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	data about sqlserver and the host its running on
2	HOSTNAME	☐	MSSHOSTNM_	TEXT30	CHAR	30	0	Hostname of the application server logged into SQL Server
3	SQLVERSION	☐	MSQVERSN	CHAR50	CHAR	50	0	Version of the database management system.
4	SQLBUILDNM	☐	MSQDBVER	INT4	INT4	10	0	SQL Server build number (corresponding to a Service Pack).
5	PRODLEVEL	☐	MSQSSBLDDT	CHAR12	CHAR	12	0	Date the executable sqlservr.exe was created.
6	SQLSTARTTM	☐	MSQDBUPTME	CHAR20	CHAR	20	0	Date and time of last SQL Server start.
7	SQLEE	☐	MSQSSSQLEE	CHAR1	CHAR	1	0	SQL Server edition: 'X' = Enterprise Ed., 'C' Cluster in use
8	NTVER	☐	MSQSSNTEE	CHAR1	CHAR	1	0	OS edition: A=Advanced Server, S=Server, D=Datacenter.
9	PARAMDIFF	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
10	DISKPERF	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
11	ISCLUSTER	☐	MSSISCLUSTER	CHAR1	CHAR	1	0	Is SQL Server clustered 'Y' or 'N'
12	IS3GB	☐	MSSIS3GB	CHAR1	CHAR	1	0	Is SQL Server on machine with /3GB switch on 'Y' or 'N'
13	ISPAE	☐	MSSISPAE	CHAR1	CHAR	1	0	Is SQL Server on machine with PAE 'Y' or 'N'
14	ISAWE	☐	MSSISAWE	CHAR1	CHAR	1	0	Is SQL Server AWE enabled Y' or 'N'
15	CHIP	☐	MSQSSCHIP	CHAR20	CHAR	20	0	Processor type being used on the host running SQL Server.
16	WINVER	☐	MSQSSWVER	CHAR80	CHAR	80	0	Operating system version running on SQL Server host.
17	NUMCPUS	☐	MSQSSCPUS	INT4	INT4	10	0	Number of CPUs on the host which runs SQL Server.
18	SQLCPUS	☐	MSQSQLCPUS	INT4	INT4	10	0	Maximum number of CPUs SQL Server is configured to use.
19	MASK	☐	MSQSSMASK	CHAR08	CHAR	8	0	Bitmask representing the CPUs available to Windows.
20	PHYMEM	☐	MSQSSRAM	INT4	INT4	10	0	Amount of RAM on the server running SQL Server
21	TRACEFLAGS	☐	MSQSSTFLG	CHAR255	CHAR	255	0	Trace flags which are currently set for SQL Server.
22	MEMSETTING	☐	MSQMEMSET	CHAR010	CHAR	10	0	Specifies how SQL Server memory parameters have been set
23	AGTLOGLOC	☐	MSSPATH	MSSCSC255	CHAR	255	0	UNC path to a file used by SQL Server
24	ERRLOGLOC	☐	MSSPATH	MSSCSC255	CHAR	255	0	UNC path to a file used by SQL Server
25	.INCLUDE	☐				0	0	Contains data from sysperfinfo on memory
26	CONNECTMEM	☐	MSSPMCONN		DEC	23	0	Amount of dynamic memory the server is using for connections
27	WRKPROCMEM	☐	MSSPMGWSPM		DEC	23	0	Amount of memory granted to executing processes in KB
28	LOCKMEMORY	☐	MSSPMLCKM		DEC	23	0	Amount of dynamic memory used for locks in KB
29	MAXWSPMEM	☐	MSSPMMWSPM		DEC	23	0	Maximum amount of memory available for executing SQL process
30	OPTQRYMEM	☐	MSSPMOPMEM		DEC	23	0	Amount of memory SQL Server is using for query optimization
31	SQLCACMEM	☐	MSSPMCACM		DEC	23	0	Amount of memory being used for dynamic SQL cache in KB
32	TARSRVMEM	☐	MSSPMTARSM		DEC	23	0	Amount of memory SQL Server is willing to consume in KB
33	TTLSRVMEM	☐	MSSPMTTLSM		DEC	23	0	Amount of memory SQL Server is currently using in KB.
34	USERCONCTS	☐	MSSPSUSCON		DEC	23	0	Number of user connections to the SQL Server system
35	CACHEHIT	☐	MSSPBCACHT		DEC	13	3	Percentage of pages found in the buffer cache
36	DATACACHSZ	☐	MSSPBDATAC		DEC	23	0	Size in KB of the data cache, including unused space
37	CACHESIZE	☐	MSSPBCACSZ		DEC	23	0	Size in KB of the procedure cache, including unused space.
38	BUFFCOMMIT	☐	MSSPBCOMIT		DEC	23	0	Number of committed pages in cache.
39	FREEBUFFER	☐	MSSPBFREBF		DEC	23	0	Number of free pages available in cache.
40	STLPAGECNT	☐	MSSPBSTPCT		DEC	23	0	Number of buffer pages taken for other memory requirements
41	.INCLUDE	☐				0	0	Contains data from sysperfinfo on accesses physical&logical
42	FULLSCANS	☐	MSSPAFULLS		DEC	23	0	Number of unrestricted base table or index scans
43	INDEXSRCH	☐	MSSPAIDXSR		DEC	23	0	Number of index searches
44	EXTALLOCS	☐	MSSPAEXAL		DEC	23	0	Number of extents allocated to database objects
45	EXTDEALLS	☐	MSSPAEXDE		DEC	23	0	Number of extents deallocated in a database
46	PAGEALLOCS	☐	MSSPAPGAL		DEC	23	0	Number of pages allocated to database objects
47	PAGEDEALLS	☐	MSSPAPGDE		DEC	23	0	Number of pages deallocated in a database
48	PAGESPLITS	☐	MSSPAPGSPL		DEC	23	0	Number of index page splits in a database
49	PROBESCANS	☐	MSSPAPRBSN		DEC	23	0	Number of probe scans in a database
50	RANGESCANS	☐	MSSPARNGSN		DEC	23	0	Number of range scans through indexes
51	WORKFILES	☐	MSSPAWFCRE		DEC	23	0	Number of work files created
52	WORKTABLES	☐	MSSPAWTCRE		DEC	23	0	Number of work tables created
53	LAZYWRITES	☐	MSSPBLZWTS		DEC	23	0	Number of pages written by the lazy writer to disk.
54	PAGEREADS	☐	MSSPBPGRDS		DEC	23	0	Number of physical page reads
55	PAGEWRITES	☐	MSSPBPGWRT		DEC	23	0	Number of physical page writes
56	REQBUFFPG	☐	MSSPBUFREQ		DEC	23	0	Number of requests to find a page in the buffer pool.
57	READAHEAD	☐	MSSPBRAPGS		DEC	23	0	Number of pages read in anticipation of use.
58	AUTOPARAM	☐	MSSPSAUTO		DEC	23	0	Number of auto-parameterization attempts
59	SQLBATCHS	☐	MSSPSBATCH		DEC	23	0	Number of SQL batch requests received by server.
60	SQLCOMPILE	☐	MSSPSQLCMP		DEC	23	0	Number of SQL compilations
61	AVGLTCHWT	☐	MSSPSALTWT		DEC	23	0	Average wait time in ms for latch requests that waited.
62	LATCHWAITS	☐	MSSPSLTHWT		DEC	23	0	Number of latch requests that had to wait before granted.
63	.INCLUDE	☐				0	0	Database size information
64	DB_SIZE	☐	MSS_DBSIZE		DEC	15	0	Database size in MB
65	DB_ALLOC	☐	MSS_DBALLOC		DEC	15	0	Allocated space in database in MB
66	LOG_SIZE	☐	MSS_LOGSIZE		DEC	15	0	Log size in MB
67	LOG_ALLOC	☐	MSS_LOGALLOC		DEC	15	0	Allocated space in log in MB
68	.INCLUDE	☐				0	0	Information on the total size of all tables
69	RESERVED	☐	MSSRESSIZE		DEC	15	0	Reserved size in KB
70	NUMTABS	☐	MSSNUMTABLES		INT4	10	0	Number of user tables
71	TABDATA	☐	MSSDATASIZE		DEC	15	0	Data size in KB
72	NUMINDS	☐	MSSNUMINDEXES		INT4	10	0	Number of indexes of user tables
73	INDDATA	☐	MSSINDEXSIZE		DEC	15	0	Index size in KB
74	UNUSED	☐	MSSUNUSEDSIZE		DEC	15	0	Unused size in KB
75	NUMPROCS	☐	MSSNUMPROCS		INT4	10	0	Number of stored procedures created in DBI
76	.INCLUDE	☐				0	0	contains performance measures since sqlserver's last start
77	SQLUPTIME	☐	MSQDSSQLSC	INT4	INT4	10	0	Number of seconds SQL Server has been running.
78	CPUBUSY	☐	MSQDSCPUBY	INT4	INT4	10	0	Number of seconds CPUs have been busy (sum for all CPUs) .
79	CPUIDLE	☐	MSQDSCPUID	INT4	INT4	10	0	Number of seconds CPUs have been idle (sum for all CPUs) .
80	IOBUSY	☐	MSQDSIOBSY	INT4	INT4	10	0	Number of seconds SQL Server tasks were busy with IO.
81	PCTCPU	☐	MSQDSCPPCT	INT4	INT4	10	0	Percent of time the CPUs have been busy.
82	PCTIDLE	☐	MSQDSIDPCT	INT4	INT4	10	0	Percent of time CPUs have been idle.
83	PCTIO	☐	MSQDSIOPCT	INT4	INT4	10	0	Percent of time SQL Server tasks have beeen busy whit IO.
84	PACKRECD	☐	MSQDSPCKRD	INT4	INT4	10	0	Number of network packets received.
85	PACKSENT	☐	MSQDSPCKST	INT4	INT4	10	0	Number of network packets sent out by SQL Server.
86	CONNECTS	☐	MSQDSCONN	INT4	INT4	10	0	Number of attempted connections to SQL Server.
87	PACKERRORS	☐	MSQDSPCKER	INT4	INT4	10	0	Number of network packets with error since SQL Server start.
88	TOTALREAD	☐	MSQDSTOTRD	INT4	INT4	10	0	Number of disk reads done by SQL Server (physical reads).
89	TOTALWRITE	☐	MSQDSTOTWR	INT4	INT4	10	0	Number of physical disk writes done by SQL Server.
90	TOTALERROR	☐	MSQDSTOTER	INT4	INT4	10	0	Number of disk read or write errors since SQL Server started
91	.INCLUDE	☐				0	0	Contains data from the performance object cache manager
92	CACHETYPE	☐	MSSPCTYPE	CHAR40	CHAR	40	0	Type of object in SQL Server procedure cache.
93	HITRATIO	☐	MSSPCRATIO		DEC	13	3	Procedure cache hit ratio as percentage.
94	OBJECTCNT	☐	MSSPCOBJCT		DEC	23	0	Number of objects stored in the procedure cache.
95	OBJPAGES	☐	MSSPCPAGES		DEC	23	0	Number of pages used by this object type in the cache.
96	USECOUNTS	☐	MSSPCUSECT		DEC	23	0	Number of times an object of this type has been used.
97	R3USERS	☐	MSQDBSAPPC	INT4	INT4	10	0	Number of connections to SAP database from SAP application.
98	OTHERUSER	☐	MSQDBNUMPC	INT4	INT4	10	0	Number of non-SAP processes connected to SAP database.
99	UNIUSER	☐	MSQDBNDUSR	INT4	INT4	10	0	Number of different users connected to SAP database

History

Last changed by/on	SAP	20110908
SAP Release Created in