SAP ABAP Table MSQPROCACH (MS SQL server procedure cache activity)
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
⤷ 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 | MSQPROCACH | Table Relationship Diagram |
Short Description | MS SQL server procedure cache activity |
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 | NUMPRBUF | MSQPROCBUF | INT4 | INT4 | 10 | 0 | MS SQL server number of procedures in cache | ||
2 | NUMPRBUFUS | MSQPROCUSD | INT4 | INT4 | 10 | 0 | MS SQL server - number of cache slots holding stored procs | ||
3 | NUMPRBUFAC | MSQPROCACT | INT4 | INT4 | 10 | 0 | MS SQL server - number of active stored procedures in slots | ||
4 | PROCACHESZ | MSQCFCACHE | INT4 | INT4 | 10 | 0 | MS SQL server - configured procedure cache size | ||
5 | PROCACHEUS | MSQCACHEUS | INT4 | INT4 | 10 | 0 | MS SQL server - No. of proc cache slots holding stored proc | ||
6 | PROCACHEAC | MSQCACHEAC | INT4 | INT4 | 10 | 0 | MS SQL server - Number of stored procedures active |
History
Last changed by/on | SAP | 20110908 |
SAP Release Created in |