SAP ABAP Table MSSCOLLCOUNTERS (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	MSSCOLLCOUNTERS	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	PGWRITEWAITMS	☐	MSSPGWRITEWAIT	MSSCOLLSLOPE	DEC	16	3	Wait time per page write request
2	IOSTALLREADSRV	☐	MSSIOSTALLREAD	MSSCOLLSLOPE	DEC	16	3	IOStall per read request
3	IOSTALLWRITESRV	☐	MSSIOSTALLWRITE	MSSCOLLSLOPE	DEC	16	3	IOStall per read request
4	IOSTALLREADDB	☐	MSSIOSTALLREAD	MSSCOLLSLOPE	DEC	16	3	IOStall per read request
5	IOSTALLWRITEDB	☐	MSSIOSTALLWRITE	MSSCOLLSLOPE	DEC	16	3	IOStall per read request
6	LOGWRITEWAITMS	☐	MSSLOGWRITEWAIT	MSSCOLLSLOPE	DEC	16	3	Wait time per log write request
7	LOGFLUSHWAITMS	☐	MSSLOGFLUSHWAIT	MSSCOLLSLOPE	DEC	16	3	Wait time per log flush
8	LOGFLUSHS	☐	MSSLOGFLUSHS	MSSCOLLSLOPE	DEC	16	3	Log flushes per sec
9	LOGFLUSHSDB	☐	MSSLOGFLUSHS	MSSCOLLSLOPE	DEC	16	3	Log flushes per sec
10	LOGFLUSHSSRV	☐	MSSLOGFLUSHS	MSSCOLLSLOPE	DEC	16	3	Log flushes per sec
11	PHYSREADSDB	☐	MSSPHYSREADSDB	MSSCOLLSLOPE	DEC	16	3	Physical reads per database in a second
12	PHYSWRITESDB	☐	MSSPHYSWRITESDB	MSSCOLLSLOPE	DEC	16	3	Physical writes per database in a second
13	PHYSREADSSRV	☐	MSSPHYSREADSSRV	MSSCOLLSLOPE	DEC	16	3	Physical reads for whole server in a second
14	PHYSWRITESSRV	☐	MSSPHYSWRITESSRV	MSSCOLLSLOPE	DEC	16	3	Physical writes for whole server in a second
15	BUFPGWAITMS	☐	MSSPGLATCHWAIT	MSSCOLLSLOPE	DEC	16	3	Wait time per buffer page latch request
16	BUFPGLOOKUPS	☐	MSSBUFPGLOOKUPS	MSSCOLLSLOPE	DEC	16	3	Number of buffer page lookups per batch
17	BUFPGREADS	☐	MSSBUFPGREADS	MSSCOLLSLOPE	DEC	16	3	Reads triggered by buffer management
18	BUFPGWRITES	☐	MSSBUFPGWRITES	MSSCOLLSLOPE	DEC	16	3	writes per second triggered by buffer management
19	PAGEREADSPLKP	☐	MSSPAGEREADSPLK	MSSCOLLSLOPE	DEC	16	3	Page reads per buffer lookup
20	READAHEADS	☐	MSSREADAHEAD	MSSCOLLSLOPE	DEC	16	3	Page reads per read ahead
21	READ_READAHEADS	☐	MSSREADAHEAD	MSSCOLLSLOPE	DEC	16	3	Page reads per read ahead
22	CPUBUSY	☐	MSSCPUBUSY	MSSCOLLSLOPE	DEC	16	3	SQL Server CPU busy counter
23	CPUIDLE	☐	MSSCPUIDLE	MSSCOLLSLOPE	DEC	16	3	SQL Server CPU idle counter
24	IOBUSY	☐	MSSIOBUSY	MSSCOLLSLOPE	DEC	16	3	SQL Server IO busy counter
25	CPUINFO	☐	MSSCPUINFO		CHAR	15	0	CPU information (number of CPUs used)
26	LAZYWRITES	☐	MSSLAZYWRITES	MSSCOLLSLOPE	DEC	16	3	Lazy writes (per second)
27	BUFHITRATIO	☐	MSSBUFHITRATIO	MSSCOLLSLOPE	DEC	16	3	Datacache hit ratio
28	CACHEHITRATIO	☐	MSSCACHEHITRATIO	MSSCOLLSLOPE	DEC	16	3	Procedure cache hit ratio
29	LOCKWAITMS	☐	MSSLOCKWAITMS	MSSCOLLSLOPE	DEC	16	3	Average lock wait time per request
30	LOCKESCAL	☐	MSSLOCKESC	MSSCOLLSLOPE	DEC	16	3	Average lock escalations per second
31	LOCKREQ	☐	MSSLOCKREQ	MSSCOLLSLOPE	DEC	16	3	Number of lock requests per second
32	LATCHWAITMS	☐	MSSLATCHWAITMS	MSSCOLLSLOPE	DEC	16	3	Average latch wait per request (ms)
33	FULLSCANS	☐	MSSFULLSCANS	MSSCOLLSLOPE	DEC	16	3	Number of full scans per second
34	CHECKPOINTWAITS	☐	MSSCHKPTWAITS	MSSCOLLSLOPE	DEC	16	3	Check point waits
35	CHECKPOINTPGS	☐	MSSCHKPTPAGES	MSSCOLLSLOPE	DEC	16	3	Check point pages written
36	TOTALMEM	☐	MSSCURRMEM	MSSCOLLMEMSIZE	DEC	16	1	Currently used SQL Server memory
37	SQLCACHEMEM	☐	MSSSQLCACHEMEM	MSSCOLLMEMSIZE	DEC	16	1	SQL Server SQL cache memory
38	CURRMEM	☐	MSSCURRMEM	MSSCOLLMEMSIZE	DEC	16	1	Currently used SQL Server memory
39	LOCKMEM	☐	MSSLOCKMEM	MSSCOLLMEMSIZE	DEC	16	1	SQL Server Memory currently used for locking
40	CONNMEM	☐	MSSCONNMEM	MSSCOLLMEMSIZE	DEC	16	1	Connection Memory sor all SQL Server connections
41	OPTMEM	☐	MSSOPTMEM	MSSCOLLMEMSIZE	DEC	16	1	Memory for SQL Server Optimizer
42	TARGETMEM	☐	MSSMAXMEM	MSSCOLLMEMSIZE	DEC	16	1	Max memory limit for SQL Server
43	DATABASEPGS	☐	MSSDATABASEPGS	MSSCOLLMEMSIZE	DEC	16	1	Datacache size in MB
44	FREEPAGES	☐	MSSFREEPGSZ	MSSCOLLMEMSIZE	DEC	16	1	Free pages in MB
45	PROCCACHEPGS	☐	MSSPROCCACHESZ	MSSCOLLMEMSIZE	DEC	16	1	Size of the SQL Server procedure cache
46	CACHEPGS	☐	MSSCACHESZ	MSSCOLLMEMSIZE	DEC	16	1	Size of whole SQL Server procedure cache
47	TOTALBUFPGS	☐	MSSTOTALBUFPGS	MSSCOLLMEMSIZE	DEC	16	1	Total number of pages (buffer manager)
48	CACHEOBJCNT	☐	INT4	INT4	INT4	10	0	Natural number
49	TRANSACTIONS	☐	MSSTRANSACTIONS	MSSCOLLSLOPE	DEC	16	3	Transactions per second
50	ACTTRANSACTIONS	☐	MSSTRANSACTIONS	MSSCOLLSLOPE	DEC	16	3	Transactions per second

History

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