Data Element list used by SAP ABAP Table MSSCOLLCOUNTERS (Collection of key performance counters displayed in ST04)
SAP ABAP Table MSSCOLLCOUNTERS (Collection of key performance counters displayed in ST04) is using
# | Object Type | Object Name | Object Description | Note |
---|---|---|---|---|
1 | Data Element | INT4 | Natural number | |
2 | Data Element | MSSBUFHITRATIO | Datacache hit ratio | |
3 | Data Element | MSSBUFPGLOOKUPS | Number of buffer page lookups per batch | |
4 | Data Element | MSSBUFPGREADS | Reads triggered by buffer management | |
5 | Data Element | MSSBUFPGWRITES | writes per second triggered by buffer management | |
6 | Data Element | MSSCACHEHITRATIO | Procedure cache hit ratio | |
7 | Data Element | MSSCACHESZ | Size of whole SQL Server procedure cache | |
8 | Data Element | MSSCHKPTPAGES | Check point pages written | |
9 | Data Element | MSSCHKPTWAITS | Check point waits | |
10 | Data Element | MSSCONNMEM | Connection Memory sor all SQL Server connections | |
11 | Data Element | MSSCPUBUSY | SQL Server CPU busy counter | |
12 | Data Element | MSSCPUIDLE | SQL Server CPU idle counter | |
13 | Data Element | MSSCPUINFO | CPU information (number of CPUs used) | |
14 | Data Element | MSSCURRMEM | Currently used SQL Server memory | |
15 | Data Element | MSSCURRMEM | Currently used SQL Server memory | |
16 | Data Element | MSSDATABASEPGS | Datacache size in MB | |
17 | Data Element | MSSFREEPGSZ | Free pages in MB | |
18 | Data Element | MSSFULLSCANS | Number of full scans per second | |
19 | Data Element | MSSIOBUSY | SQL Server IO busy counter | |
20 | Data Element | MSSIOSTALLREAD | IOStall per read request | |
21 | Data Element | MSSIOSTALLREAD | IOStall per read request | |
22 | Data Element | MSSIOSTALLWRITE | IOStall per read request | |
23 | Data Element | MSSIOSTALLWRITE | IOStall per read request | |
24 | Data Element | MSSLATCHWAITMS | Average latch wait per request (ms) | |
25 | Data Element | MSSLAZYWRITES | Lazy writes (per second) | |
26 | Data Element | MSSLOCKESC | Average lock escalations per second | |
27 | Data Element | MSSLOCKMEM | SQL Server Memory currently used for locking | |
28 | Data Element | MSSLOCKREQ | Number of lock requests per second | |
29 | Data Element | MSSLOCKWAITMS | Average lock wait time per request | |
30 | Data Element | MSSLOGFLUSHS | Log flushes per sec | |
31 | Data Element | MSSLOGFLUSHS | Log flushes per sec | |
32 | Data Element | MSSLOGFLUSHS | Log flushes per sec | |
33 | Data Element | MSSLOGFLUSHWAIT | Wait time per log flush | |
34 | Data Element | MSSLOGWRITEWAIT | Wait time per log write request | |
35 | Data Element | MSSMAXMEM | Max memory limit for SQL Server | |
36 | Data Element | MSSOPTMEM | Memory for SQL Server Optimizer | |
37 | Data Element | MSSPAGEREADSPLK | Page reads per buffer lookup | |
38 | Data Element | MSSPGLATCHWAIT | Wait time per buffer page latch request | |
39 | Data Element | MSSPGWRITEWAIT | Wait time per page write request | |
40 | Data Element | MSSPHYSREADSDB | Physical reads per database in a second | |
41 | Data Element | MSSPHYSREADSSRV | Physical reads for whole server in a second | |
42 | Data Element | MSSPHYSWRITESDB | Physical writes per database in a second | |
43 | Data Element | MSSPHYSWRITESSRV | Physical writes for whole server in a second | |
44 | Data Element | MSSPROCCACHESZ | Size of the SQL Server procedure cache | |
45 | Data Element | MSSREADAHEAD | Page reads per read ahead | |
46 | Data Element | MSSREADAHEAD | Page reads per read ahead | |
47 | Data Element | MSSSQLCACHEMEM | SQL Server SQL cache memory | |
48 | Data Element | MSSTOTALBUFPGS | Total number of pages (buffer manager) | |
49 | Data Element | MSSTRANSACTIONS | Transactions per second | |
50 | Data Element | MSSTRANSACTIONS | Transactions per second |