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
⤷ 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 |