Data Element list used by SAP ABAP Table MSQSNAP (MS SQL Server: Database performance snapshot)
SAP ABAP Table 
MSQSNAP (MS SQL Server: Database performance snapshot) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Data Element |
CHAR1 | Single-Character Flag | |
| 2 | Data Element |
CHAR1 | Single-Character Flag | |
| 3 | Data Element |
DATUM | Date | |
| 4 | Data Element |
MSQDBNDUSR | Number of different users connected to SAP database | |
| 5 | Data Element |
MSQDBNUMPC | Number of non-SAP processes connected to SAP database. | |
| 6 | Data Element |
MSQDBSAPPC | Number of connections to SAP database from SAP application. | |
| 7 | Data Element |
MSQDBUPTME | Date and time of last SQL Server start. | |
| 8 | Data Element |
MSQDBVER | SQL Server build number (corresponding to a Service Pack). | |
| 9 | Data Element |
MSQDSCONN | Number of attempted connections to SQL Server. | |
| 10 | Data Element |
MSQDSCPPCT | Percent of time the CPUs have been busy. | |
| 11 | Data Element |
MSQDSCPUBY | Number of seconds CPUs have been busy (sum for all CPUs) . | |
| 12 | Data Element |
MSQDSCPUID | Number of seconds CPUs have been idle (sum for all CPUs) . | |
| 13 | Data Element |
MSQDSIDPCT | Percent of time CPUs have been idle. | |
| 14 | Data Element |
MSQDSIOBSY | Number of seconds SQL Server tasks were busy with IO. | |
| 15 | Data Element |
MSQDSIOPCT | Percent of time SQL Server tasks have beeen busy whit IO. | |
| 16 | Data Element |
MSQDSPCKER | Number of network packets with error since SQL Server start. | |
| 17 | Data Element |
MSQDSPCKRD | Number of network packets received. | |
| 18 | Data Element |
MSQDSPCKST | Number of network packets sent out by SQL Server. | |
| 19 | Data Element |
MSQDSSQLSC | Number of seconds SQL Server has been running. | |
| 20 | Data Element |
MSQDSTOTER | Number of disk read or write errors since SQL Server started | |
| 21 | Data Element |
MSQDSTOTRD | Number of disk reads done by SQL Server (physical reads). | |
| 22 | Data Element |
MSQDSTOTWR | Number of physical disk writes done by SQL Server. | |
| 23 | Data Element |
MSQMEMSET | Specifies how SQL Server memory parameters have been set | |
| 24 | Data Element |
MSQSQLCPUS | Maximum number of CPUs SQL Server is configured to use. | |
| 25 | Data Element |
MSQSSBLDDT | Date the executable sqlservr.exe was created. | |
| 26 | Data Element |
MSQSSCHIP | Processor type being used on the host running SQL Server. | |
| 27 | Data Element |
MSQSSCPUS | Number of CPUs on the host which runs SQL Server. | |
| 28 | Data Element |
MSQSSMASK | Bitmask representing the CPUs available to Windows. | |
| 29 | Data Element |
MSQSSNTEE | OS edition: A=Advanced Server, S=Server, D=Datacenter. | |
| 30 | Data Element |
MSQSSRAM | Amount of RAM on the server running SQL Server | |
| 31 | Data Element |
MSQSSSQLEE | SQL Server edition: 'X' = Enterprise Ed., 'C' Cluster in use | |
| 32 | Data Element |
MSQSSTFLG | Trace flags which are currently set for SQL Server. | |
| 33 | Data Element |
MSQSSWVER | Operating system version running on SQL Server host. | |
| 34 | Data Element |
MSQVERSN | Version of the database management system. | |
| 35 | Data Element |
MSSDATASIZE | Data size in KB | |
| 36 | Data Element |
MSSELAPSED | MS SQL Server number of seconds elapsed since DB startup | |
| 37 | Data Element |
MSSHOSTNM_ | Hostname of the application server logged into SQL Server | |
| 38 | Data Element |
MSSINDEXSIZE | Index size in KB | |
| 39 | Data Element |
MSSIS3GB | Is SQL Server on machine with /3GB switch on 'Y' or 'N' | |
| 40 | Data Element |
MSSISAWE | Is SQL Server AWE enabled Y' or 'N' | |
| 41 | Data Element |
MSSISCLUSTER | Is SQL Server clustered 'Y' or 'N' | |
| 42 | Data Element |
MSSISPAE | Is SQL Server on machine with PAE 'Y' or 'N' | |
| 43 | Data Element |
MSSNUMINDEXES | Number of indexes of user tables | |
| 44 | Data Element |
MSSNUMPROCS | Number of stored procedures created in DBI | |
| 45 | Data Element |
MSSNUMTABLES | Number of user tables | |
| 46 | Data Element |
MSSPAEXAL | Number of extents allocated to database objects | |
| 47 | Data Element |
MSSPAEXDE | Number of extents deallocated in a database | |
| 48 | Data Element |
MSSPAFULLS | Number of unrestricted base table or index scans | |
| 49 | Data Element |
MSSPAIDXSR | Number of index searches | |
| 50 | Data Element |
MSSPAPGAL | Number of pages allocated to database objects | |
| 51 | Data Element |
MSSPAPGDE | Number of pages deallocated in a database | |
| 52 | Data Element |
MSSPAPGSPL | Number of index page splits in a database | |
| 53 | Data Element |
MSSPAPRBSN | Number of probe scans in a database | |
| 54 | Data Element |
MSSPARNGSN | Number of range scans through indexes | |
| 55 | Data Element |
MSSPATH | UNC path to a file used by SQL Server | |
| 56 | Data Element |
MSSPATH | UNC path to a file used by SQL Server | |
| 57 | Data Element |
MSSPAWFCRE | Number of work files created | |
| 58 | Data Element |
MSSPAWTCRE | Number of work tables created | |
| 59 | Data Element |
MSSPBCACHT | Percentage of pages found in the buffer cache | |
| 60 | Data Element |
MSSPBCACSZ | Size in KB of the procedure cache, including unused space. | |
| 61 | Data Element |
MSSPBCOMIT | Number of committed pages in cache. | |
| 62 | Data Element |
MSSPBDATAC | Size in KB of the data cache, including unused space | |
| 63 | Data Element |
MSSPBFREBF | Number of free pages available in cache. | |
| 64 | Data Element |
MSSPBLZWTS | Number of pages written by the lazy writer to disk. | |
| 65 | Data Element |
MSSPBPGRDS | Number of physical page reads | |
| 66 | Data Element |
MSSPBPGWRT | Number of physical page writes | |
| 67 | Data Element |
MSSPBRAPGS | Number of pages read in anticipation of use. | |
| 68 | Data Element |
MSSPBSTPCT | Number of buffer pages taken for other memory requirements | |
| 69 | Data Element |
MSSPBUFREQ | Number of requests to find a page in the buffer pool. | |
| 70 | Data Element |
MSSPCOBJCT | Number of objects stored in the procedure cache. | |
| 71 | Data Element |
MSSPCPAGES | Number of pages used by this object type in the cache. | |
| 72 | Data Element |
MSSPCRATIO | Procedure cache hit ratio as percentage. | |
| 73 | Data Element |
MSSPCTYPE | Type of object in SQL Server procedure cache. | |
| 74 | Data Element |
MSSPCUSECT | Number of times an object of this type has been used. | |
| 75 | Data Element |
MSSPMCACM | Amount of memory being used for dynamic SQL cache in KB | |
| 76 | Data Element |
MSSPMCONN | Amount of dynamic memory the server is using for connections | |
| 77 | Data Element |
MSSPMGWSPM | Amount of memory granted to executing processes in KB | |
| 78 | Data Element |
MSSPMLCKM | Amount of dynamic memory used for locks in KB | |
| 79 | Data Element |
MSSPMMWSPM | Maximum amount of memory available for executing SQL process | |
| 80 | Data Element |
MSSPMOPMEM | Amount of memory SQL Server is using for query optimization | |
| 81 | Data Element |
MSSPMTARSM | Amount of memory SQL Server is willing to consume in KB | |
| 82 | Data Element |
MSSPMTTLSM | Amount of memory SQL Server is currently using in KB. | |
| 83 | Data Element |
MSSPSALTWT | Average wait time in ms for latch requests that waited. | |
| 84 | Data Element |
MSSPSAUTO | Number of auto-parameterization attempts | |
| 85 | Data Element |
MSSPSBATCH | Number of SQL batch requests received by server. | |
| 86 | Data Element |
MSSPSLTHWT | Number of latch requests that had to wait before granted. | |
| 87 | Data Element |
MSSPSQLCMP | Number of SQL compilations | |
| 88 | Data Element |
MSSPSUSCON | Number of user connections to the SQL Server system | |
| 89 | Data Element |
MSSRESSIZE | Reserved size in KB | |
| 90 | Data Element |
MSSUNUSEDSIZE | Unused size in KB | |
| 91 | Data Element |
MSS_DBALLOC | Allocated space in database in MB | |
| 92 | Data Element |
MSS_DBSIZE | Database size in MB | |
| 93 | Data Element |
MSS_LOGALLOC | Allocated space in log in MB | |
| 94 | Data Element |
MSS_LOGSIZE | Log size in MB | |
| 95 | Data Element |
UZEIT | Time |
