SAP ABAP Table MSQSNAP (MS SQL Server: Database performance snapshot)

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	TRANSP	Transparent table
Transparent table	MSQSNAP	Table Relationship Diagram
Short Description	MS SQL Server: Database performance snapshot

Delivery and Maintenance

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

History

Last changed by/on	SAP	20110908
SAP Release Created in