SAP ABAP Table MSSSNAPHIS (MS SQL Server MSQSNAP table history list)

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	MSSSNAPHIS	Table Relationship Diagram
Short Description	MS SQL Server MSQSNAP table history list

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	WEEK	☐	KWEEK	KWEEK	ACCP	6	0	Factory calendar: Week
2	DAYOW	☐	DAYOFWEEK	CHAR7	CHAR	7	0	Day (for Collector)
3	RECORDS	☐	MSSNUMRECD	INT2	INT2	5	0	MS SQL Server peformance server: number of records
4	.INCLUDE	☐				0	0	MS SQL Server: Database performance snapshot
5	RECORDDATE	☐	DATUM	DATUM	DATS	8	0	Date
6	RECORDTIME	☐	UZEIT	UZEIT	TIMS	6	0	Time
7	ELAPSEDSEC	☐	MSSELAPSED	INT4	INT4	10	0	MS SQL Server number of seconds elapsed since DB startup
8	.INCLUDE	☐				0	0	MS SQL Server: ST04 Main Screen Display Structure
9	.INCLUDE	☐				0	0	data about sqlserver and the host its running on
10	HOSTNAME	☐	MSSHOSTNM_	TEXT30	CHAR	30	0	Hostname of the application server logged into SQL Server
11	SQLVERSION	☐	MSQVERSN	CHAR50	CHAR	50	0	Version of the database management system.
12	SQLBUILDNM	☐	MSQDBVER	INT4	INT4	10	0	SQL Server build number (corresponding to a Service Pack).
13	PRODLEVEL	☐	MSQSSBLDDT	CHAR12	CHAR	12	0	Date the executable sqlservr.exe was created.
14	SQLSTARTTM	☐	MSQDBUPTME	CHAR20	CHAR	20	0	Date and time of last SQL Server start.
15	SQLEE	☐	MSQSSSQLEE	CHAR1	CHAR	1	0	SQL Server edition: 'X' = Enterprise Ed., 'C' Cluster in use
16	NTVER	☐	MSQSSNTEE	CHAR1	CHAR	1	0	OS edition: A=Advanced Server, S=Server, D=Datacenter.
17	PARAMDIFF	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
18	DISKPERF	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
19	ISCLUSTER	☐	MSSISCLUSTER	CHAR1	CHAR	1	0	Is SQL Server clustered 'Y' or 'N'
20	IS3GB	☐	MSSIS3GB	CHAR1	CHAR	1	0	Is SQL Server on machine with /3GB switch on 'Y' or 'N'
21	ISPAE	☐	MSSISPAE	CHAR1	CHAR	1	0	Is SQL Server on machine with PAE 'Y' or 'N'
22	ISAWE	☐	MSSISAWE	CHAR1	CHAR	1	0	Is SQL Server AWE enabled Y' or 'N'
23	CHIP	☐	MSQSSCHIP	CHAR20	CHAR	20	0	Processor type being used on the host running SQL Server.
24	WINVER	☐	MSQSSWVER	CHAR80	CHAR	80	0	Operating system version running on SQL Server host.
25	NUMCPUS	☐	MSQSSCPUS	INT4	INT4	10	0	Number of CPUs on the host which runs SQL Server.
26	SQLCPUS	☐	MSQSQLCPUS	INT4	INT4	10	0	Maximum number of CPUs SQL Server is configured to use.
27	MASK	☐	MSQSSMASK	CHAR08	CHAR	8	0	Bitmask representing the CPUs available to Windows.
28	PHYMEM	☐	MSQSSRAM	INT4	INT4	10	0	Amount of RAM on the server running SQL Server
29	TRACEFLAGS	☐	MSQSSTFLG	CHAR255	CHAR	255	0	Trace flags which are currently set for SQL Server.
30	MEMSETTING	☐	MSQMEMSET	CHAR010	CHAR	10	0	Specifies how SQL Server memory parameters have been set
31	AGTLOGLOC	☐	MSSPATH	MSSCSC255	CHAR	255	0	UNC path to a file used by SQL Server
32	ERRLOGLOC	☐	MSSPATH	MSSCSC255	CHAR	255	0	UNC path to a file used by SQL Server
33	.INCLUDE	☐				0	0	Contains data from sysperfinfo on memory
34	CONNECTMEM	☐	MSSPMCONN		DEC	23	0	Amount of dynamic memory the server is using for connections
35	WRKPROCMEM	☐	MSSPMGWSPM		DEC	23	0	Amount of memory granted to executing processes in KB
36	LOCKMEMORY	☐	MSSPMLCKM		DEC	23	0	Amount of dynamic memory used for locks in KB
37	MAXWSPMEM	☐	MSSPMMWSPM		DEC	23	0	Maximum amount of memory available for executing SQL process
38	OPTQRYMEM	☐	MSSPMOPMEM		DEC	23	0	Amount of memory SQL Server is using for query optimization
39	SQLCACMEM	☐	MSSPMCACM		DEC	23	0	Amount of memory being used for dynamic SQL cache in KB
40	TARSRVMEM	☐	MSSPMTARSM		DEC	23	0	Amount of memory SQL Server is willing to consume in KB
41	TTLSRVMEM	☐	MSSPMTTLSM		DEC	23	0	Amount of memory SQL Server is currently using in KB.
42	USERCONCTS	☐	MSSPSUSCON		DEC	23	0	Number of user connections to the SQL Server system
43	CACHEHIT	☐	MSSPBCACHT		DEC	13	3	Percentage of pages found in the buffer cache
44	DATACACHSZ	☐	MSSPBDATAC		DEC	23	0	Size in KB of the data cache, including unused space
45	CACHESIZE	☐	MSSPBCACSZ		DEC	23	0	Size in KB of the procedure cache, including unused space.
46	BUFFCOMMIT	☐	MSSPBCOMIT		DEC	23	0	Number of committed pages in cache.
47	FREEBUFFER	☐	MSSPBFREBF		DEC	23	0	Number of free pages available in cache.
48	STLPAGECNT	☐	MSSPBSTPCT		DEC	23	0	Number of buffer pages taken for other memory requirements
49	.INCLUDE	☐				0	0	Contains data from sysperfinfo on accesses physical&logical
50	FULLSCANS	☐	MSSPAFULLS		DEC	23	0	Number of unrestricted base table or index scans
51	INDEXSRCH	☐	MSSPAIDXSR		DEC	23	0	Number of index searches
52	EXTALLOCS	☐	MSSPAEXAL		DEC	23	0	Number of extents allocated to database objects
53	EXTDEALLS	☐	MSSPAEXDE		DEC	23	0	Number of extents deallocated in a database
54	PAGEALLOCS	☐	MSSPAPGAL		DEC	23	0	Number of pages allocated to database objects
55	PAGEDEALLS	☐	MSSPAPGDE		DEC	23	0	Number of pages deallocated in a database
56	PAGESPLITS	☐	MSSPAPGSPL		DEC	23	0	Number of index page splits in a database
57	PROBESCANS	☐	MSSPAPRBSN		DEC	23	0	Number of probe scans in a database
58	RANGESCANS	☐	MSSPARNGSN		DEC	23	0	Number of range scans through indexes
59	WORKFILES	☐	MSSPAWFCRE		DEC	23	0	Number of work files created
60	WORKTABLES	☐	MSSPAWTCRE		DEC	23	0	Number of work tables created
61	LAZYWRITES	☐	MSSPBLZWTS		DEC	23	0	Number of pages written by the lazy writer to disk.
62	PAGEREADS	☐	MSSPBPGRDS		DEC	23	0	Number of physical page reads
63	PAGEWRITES	☐	MSSPBPGWRT		DEC	23	0	Number of physical page writes
64	REQBUFFPG	☐	MSSPBUFREQ		DEC	23	0	Number of requests to find a page in the buffer pool.
65	READAHEAD	☐	MSSPBRAPGS		DEC	23	0	Number of pages read in anticipation of use.
66	AUTOPARAM	☐	MSSPSAUTO		DEC	23	0	Number of auto-parameterization attempts
67	SQLBATCHS	☐	MSSPSBATCH		DEC	23	0	Number of SQL batch requests received by server.
68	SQLCOMPILE	☐	MSSPSQLCMP		DEC	23	0	Number of SQL compilations
69	AVGLTCHWT	☐	MSSPSALTWT		DEC	23	0	Average wait time in ms for latch requests that waited.
70	LATCHWAITS	☐	MSSPSLTHWT		DEC	23	0	Number of latch requests that had to wait before granted.
71	.INCLUDE	☐				0	0	Database size information
72	DB_SIZE	☐	MSS_DBSIZE		DEC	15	0	Database size in MB
73	DB_ALLOC	☐	MSS_DBALLOC		DEC	15	0	Allocated space in database in MB
74	LOG_SIZE	☐	MSS_LOGSIZE		DEC	15	0	Log size in MB
75	LOG_ALLOC	☐	MSS_LOGALLOC		DEC	15	0	Allocated space in log in MB
76	.INCLUDE	☐				0	0	Information on the total size of all tables
77	RESERVED	☐	MSSRESSIZE		DEC	15	0	Reserved size in KB
78	NUMTABS	☐	MSSNUMTABLES		INT4	10	0	Number of user tables
79	TABDATA	☐	MSSDATASIZE		DEC	15	0	Data size in KB
80	NUMINDS	☐	MSSNUMINDEXES		INT4	10	0	Number of indexes of user tables
81	INDDATA	☐	MSSINDEXSIZE		DEC	15	0	Index size in KB
82	UNUSED	☐	MSSUNUSEDSIZE		DEC	15	0	Unused size in KB
83	NUMPROCS	☐	MSSNUMPROCS		INT4	10	0	Number of stored procedures created in DBI
84	.INCLUDE	☐				0	0	contains performance measures since sqlserver's last start
85	SQLUPTIME	☐	MSQDSSQLSC	INT4	INT4	10	0	Number of seconds SQL Server has been running.
86	CPUBUSY	☐	MSQDSCPUBY	INT4	INT4	10	0	Number of seconds CPUs have been busy (sum for all CPUs) .
87	CPUIDLE	☐	MSQDSCPUID	INT4	INT4	10	0	Number of seconds CPUs have been idle (sum for all CPUs) .
88	IOBUSY	☐	MSQDSIOBSY	INT4	INT4	10	0	Number of seconds SQL Server tasks were busy with IO.
89	PCTCPU	☐	MSQDSCPPCT	INT4	INT4	10	0	Percent of time the CPUs have been busy.
90	PCTIDLE	☐	MSQDSIDPCT	INT4	INT4	10	0	Percent of time CPUs have been idle.
91	PCTIO	☐	MSQDSIOPCT	INT4	INT4	10	0	Percent of time SQL Server tasks have beeen busy whit IO.
92	PACKRECD	☐	MSQDSPCKRD	INT4	INT4	10	0	Number of network packets received.
93	PACKSENT	☐	MSQDSPCKST	INT4	INT4	10	0	Number of network packets sent out by SQL Server.
94	CONNECTS	☐	MSQDSCONN	INT4	INT4	10	0	Number of attempted connections to SQL Server.
95	PACKERRORS	☐	MSQDSPCKER	INT4	INT4	10	0	Number of network packets with error since SQL Server start.
96	TOTALREAD	☐	MSQDSTOTRD	INT4	INT4	10	0	Number of disk reads done by SQL Server (physical reads).
97	TOTALWRITE	☐	MSQDSTOTWR	INT4	INT4	10	0	Number of physical disk writes done by SQL Server.
98	TOTALERROR	☐	MSQDSTOTER	INT4	INT4	10	0	Number of disk read or write errors since SQL Server started
99	.INCLUDE	☐				0	0	Contains data from the performance object cache manager
100	CACHETYPE	☐	MSSPCTYPE	CHAR40	CHAR	40	0	Type of object in SQL Server procedure cache.
101	HITRATIO	☐	MSSPCRATIO		DEC	13	3	Procedure cache hit ratio as percentage.
102	OBJECTCNT	☐	MSSPCOBJCT		DEC	23	0	Number of objects stored in the procedure cache.
103	OBJPAGES	☐	MSSPCPAGES		DEC	23	0	Number of pages used by this object type in the cache.
104	USECOUNTS	☐	MSSPCUSECT		DEC	23	0	Number of times an object of this type has been used.
105	R3USERS	☐	MSQDBSAPPC	INT4	INT4	10	0	Number of connections to SAP database from SAP application.
106	OTHERUSER	☐	MSQDBNUMPC	INT4	INT4	10	0	Number of non-SAP processes connected to SAP database.
107	UNIUSER	☐	MSQDBNDUSR	INT4	INT4	10	0	Number of different users connected to SAP database

History

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