SAP ABAP Table MSSST04COUNTERS (Collection of key performance counters displayed in ST04)

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	MSSST04COUNTERS	Table Relationship Diagram
Short Description	Collection of key performance counters displayed in ST04

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	PGLATCHWAITMS	☐	MSSPGLATCHWAIT	MSSCOLLSLOPE	DEC	16	3	Wait time per buffer page latch request
2	LOGWRITEWAITMS	☐	MSSLOGWRITEWAIT	MSSCOLLSLOPE	DEC	16	3	Wait time per log write request
3	LOGFLUSHWAITMS	☐	MSSLOGFLUSHWAIT	MSSCOLLSLOPE	DEC	16	3	Wait time per log flush
4	LOGFLUSHES	☐	MSSLOGFLUSHES	MSSCOLLSLOPE	DEC	16	3	Number of log flushes
5	IOSTALLREAD	☐	MSSIOSTALLREAD	MSSCOLLSLOPE	DEC	16	3	IOStall per read request
6	IOSTALLWRITE	☐	MSSIOSTALLWRITE	MSSCOLLSLOPE	DEC	16	3	IOStall per read request
7	PHYSREADSDB	☐	MSSPHYSREADSDB	MSSCOLLSLOPE	DEC	16	3	Physical reads per database in a second
8	PHYSWRITESDB	☐	MSSPHYSWRITESDB	MSSCOLLSLOPE	DEC	16	3	Physical writes per database in a second
9	PHYSREADSSRV	☐	MSSPHYSREADSSRV	MSSCOLLSLOPE	DEC	16	3	Physical reads for whole server in a second
10	PHYSWRITESSRV	☐	MSSPHYSWRITESSRV	MSSCOLLSLOPE	DEC	16	3	Physical writes for whole server in a second
11	BUFPGWAITMS	☐	MSSBUFPGWAIT	MSSCOLLSLOPE	DEC	16	3	Wait time to read a page into buffer
12	BUFPGLOOKUPS	☐	MSSBUFPGLOOKUPS	MSSCOLLSLOPE	DEC	16	3	Number of buffer page lookups per batch
13	PAGEREADSPLKP	☐	MSSPAGEREADSPLK	MSSCOLLSLOPE	DEC	16	3	Page reads per buffer lookup
14	READ_READAHEAD	☐	MSSREADAHEAD	MSSCOLLSLOPE	DEC	16	3	Page reads per read ahead
15	SQLBATCHES	☐	MSSSQLBATCHES	MSSCOLLSLOPE	DEC	16	3	Number of SQL Batches (per second)
16	TRANSACTIONS	☐	MSSTRANSACTIONS	MSSCOLLSLOPE	DEC	16	3	Transactions per second
17	FULLSCANS	☐	MSSFULLSCANS	MSSCOLLSLOPE	DEC	16	3	Number of full scans per second
18	RANGESCANS	☐	MSSRANGESCANS	MSSCOLLSLOPE	DEC	16	3	Number of range scans per second
19	IDXSEARCHES	☐	MSSIDXSEARCHES	MSSCOLLSLOPE	DEC	16	3	Number of index searches per second
20	PROBESCANS	☐	MSSPROBESCANS	MSSCOLLSLOPE	DEC	16	3	Number of probe scans per second
21	CPUBUSY	☐	MSSCPUBUSY	MSSCOLLSLOPE	DEC	16	3	SQL Server CPU busy counter
22	CPUIDLE	☐	MSSCPUIDLE	MSSCOLLSLOPE	DEC	16	3	SQL Server CPU idle counter
23	IOBUSY	☐	MSSIOBUSY	MSSCOLLSLOPE	DEC	16	3	SQL Server IO busy counter
24	LAZYWRITES	☐	MSSLAZYWRITES	MSSCOLLSLOPE	DEC	16	3	Lazy writes (per second)
25	SAPRL	☐	MSSSAPRL		CHAR	4	0	SAP Release for SQL Server Monitor
26	CPUINFO	☐	MSSCPUINFO		CHAR	15	0	CPU information (number of CPUs used)
27	TRACEFLAGS	☐	MSQSSTFLG	CHAR255	CHAR	255	0	Trace flags which are currently set for SQL Server.
28	TOTALCONNECTS	☐	MSSTOTLCONS		INT4	10	0	Number of total connections to SQL Server
29	DBCONNECTS	☐	MSSDBCONS		INT4	10	0	Number of Connections to current database
30	PHYSMEM	☐	MSSPHYSMEM	MSSCOLLMEMSIZE	DEC	16	1	Physical available memory
31	CURRMEM	☐	MSSCURRMEM	MSSCOLLMEMSIZE	DEC	16	1	Currently used SQL Server memory
32	MAXMEM	☐	MSSMAXMEM	MSSCOLLMEMSIZE	DEC	16	1	Max memory limit for SQL Server
33	LOCKMEM	☐	MSSLOCKMEM	MSSCOLLMEMSIZE	DEC	16	1	SQL Server Memory currently used for locking
34	MEMSET	☐	MSQMEMSET	CHAR010	CHAR	10	0	Specifies how SQL Server memory parameters have been set
35	MEMOPT	☐	MSSMEMOPT		CHAR	20	0	Memory options for SQL Server/NT (3 GB, AWE)
36	DATABUFFERSZ	☐	MSSDATABASEPGS	MSSCOLLMEMSIZE	DEC	16	1	Datacache size in MB
37	CACHESZ	☐	MSSCACHESZ	MSSCOLLMEMSIZE	DEC	16	1	Size of whole SQL Server procedure cache
38	FREEPGSZ	☐	MSSFREEPGSZ	MSSCOLLMEMSIZE	DEC	16	1	Free pages in MB
39	BUFHITRATIO	☐	MSSBUFHITRATIO	MSSCOLLSLOPE	DEC	16	3	Datacache hit ratio
40	CACHEHITRATIO	☐	MSSCACHEHITRATIO	MSSCOLLSLOPE	DEC	16	3	Procedure cache hit ratio
41	WINVER	☐	MSQSSWVER	CHAR80	CHAR	80	0	Operating system version running on SQL Server host.
42	SQLVERSION	☐	MSSSQLVER		CHAR	100	0	SQL Server Version
43	TOTDBSZ	☐	MSS_DBSIZE		DEC	15	0	Database size in MB
44	DBFREE	☐	MSS_DBFREESIZE		INT4	10	0	Free space in database in MB
45	TOTLOGSZ	☐	MSS_LOGSIZE		DEC	15	0	Log size in MB
46	LOGFREE	☐	MSS_LOGFREESIZE		INT4	10	0	Free log space in MB
47	DBSTRTDATE	☐	MSSDBSTARTDATE	SYDATS	DATS	8	0	Date when SQL Server was started
48	DBSTRTTIME	☐	MSSDBSTARTTIME	SYTIME	TIMS	6	0	Time when SQL Server was started
49	ANALYSISDATE	☐	MSSANADATE	SYDATS	DATS	8	0	Date when analysis data was read
50	ANALYSISTIME	☐	MSSANATIME	SYTIME	TIMS	6	0	Time when analysis data was read

History

Last changed by/on	SAP	20110908
SAP Release Created in	640