SAP ABAP Table MSS_PACCES (Contains data from sysperfinfo on accesses physical&logical)
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 MSS_PACCES   Table Relationship Diagram
Short Description Contains data from sysperfinfo on accesses physical&logical    
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 FULLSCANS MSSPAFULLS   DEC 23   0   Number of unrestricted base table or index scans  
2 INDEXSRCH MSSPAIDXSR   DEC 23   0   Number of index searches  
3 EXTALLOCS MSSPAEXAL   DEC 23   0   Number of extents allocated to database objects  
4 EXTDEALLS MSSPAEXDE   DEC 23   0   Number of extents deallocated in a database  
5 PAGEALLOCS MSSPAPGAL   DEC 23   0   Number of pages allocated to database objects  
6 PAGEDEALLS MSSPAPGDE   DEC 23   0   Number of pages deallocated in a database  
7 PAGESPLITS MSSPAPGSPL   DEC 23   0   Number of index page splits in a database  
8 PROBESCANS MSSPAPRBSN   DEC 23   0   Number of probe scans in a database  
9 RANGESCANS MSSPARNGSN   DEC 23   0   Number of range scans through indexes  
10 WORKFILES MSSPAWFCRE   DEC 23   0   Number of work files created  
11 WORKTABLES MSSPAWTCRE   DEC 23   0   Number of work tables created  
12 LAZYWRITES MSSPBLZWTS   DEC 23   0   Number of pages written by the lazy writer to disk.  
13 PAGEREADS MSSPBPGRDS   DEC 23   0   Number of physical page reads  
14 PAGEWRITES MSSPBPGWRT   DEC 23   0   Number of physical page writes  
15 REQBUFFPG MSSPBUFREQ   DEC 23   0   Number of requests to find a page in the buffer pool.  
16 READAHEAD MSSPBRAPGS   DEC 23   0   Number of pages read in anticipation of use.  
17 AUTOPARAM MSSPSAUTO   DEC 23   0   Number of auto-parameterization attempts  
18 SQLBATCHS MSSPSBATCH   DEC 23   0   Number of SQL batch requests received by server.  
19 SQLCOMPILE MSSPSQLCMP   DEC 23   0   Number of SQL compilations  
20 AVGLTCHWT MSSPSALTWT   DEC 23   0   Average wait time in ms for latch requests that waited.  
21 LATCHWAITS MSSPSLTHWT   DEC 23   0   Number of latch requests that had to wait before granted.  
History
Last changed by/on SAP  20110908 
SAP Release Created in 610