SAP ABAP Table MSSPFSTATS (Display MSQSNAP table: Statistics)

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	MSSPFSTATS	Table Relationship Diagram
Short Description	Display MSQSNAP table: Statistics

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	DAYOW	☐	DAYOFWEEK	CHAR7	CHAR	7	0	Day (for Collector)
2	RECORDDATE	☐	DATUM	DATUM	DATS	8	0	Date
3	RECORDTIME	☐	UZEIT	UZEIT	TIMS	6	0	Time
4	REQBUFFPG	☐	MSSPBUFREQ		DEC	23	0	Number of requests to find a page in the buffer pool.
5	SQLBATCHS	☐	MSSPSBATCH		DEC	23	0	Number of SQL batch requests received by server.
6	READSPEREQ	☐	MSQRDPREQ	DEC10_2	DEC	10	2	MS SQL Server reads per SQL request
7	FULLSCANS	☐	MSSPAFULLS		DEC	23	0	Number of unrestricted base table or index scans
8	INDEXSRCH	☐	MSSPAIDXSR		DEC	23	0	Number of index searches
9	RANGESCANS	☐	MSSPARNGSN		DEC	23	0	Number of range scans through indexes
10	PROBESCANS	☐	MSSPAPRBSN		DEC	23	0	Number of probe scans in a database
11	WORKFILES	☐	MSSPAWFCRE		DEC	23	0	Number of work files created
12	WORKTABLES	☐	MSSPAWTCRE		DEC	23	0	Number of work tables created
13	SQLCOMPILE	☐	MSSPSQLCMP		DEC	23	0	Number of SQL compilations
14	AVGLTCHWT	☐	MSSPSALTWT		DEC	23	0	Average wait time in ms for latch requests that waited.
15	LATCHWAITS	☐	MSSPSLTHWT		DEC	23	0	Number of latch requests that had to wait before granted.
16	AUTOPARAM	☐	MSSPSAUTO		DEC	23	0	Number of auto-parameterization attempts

History

Last changed by/on	SAP	20130604
SAP Release Created in	610