MSQSNAP - MS SQL Server: Database performance snapshot
MS SQL Server: Database performance snapshot information is stored in SAP table MSQSNAP.
It is part of development package STUN_MSS in software component BC-DB-MSS. This development package consists of objects that can be grouped under "Package for new SQL Server monitoring objects".
It is part of development package STUN_MSS in software component BC-DB-MSS. This development package consists of objects that can be grouped under "Package for new SQL Server monitoring objects".
Fields for table MSQSNAP
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| RECORDDATE | Date | X | DATUM | DATS | 8 | |
| RECORDTIME | Time | X | UZEIT | TIMS | 6 | |
| ELAPSEDSEC | MS SQL Server number of seconds elapsed since DB startup | MSSELAPSED | INT4 | 4 | ||
| .INCLUDE | MSSST04LST | 0 | ||||
| .INCLUDE | MSS_STSERV | 0 | ||||
| HOSTNAME | Hostname of the application server logged into SQL Server | MSSHOSTNM_ | CHAR | 30 | ||
| SQLVERSION | Version of the database management system. | MSQVERSN | CHAR | 50 | ||
| SQLBUILDNM | SQL Server build number (corresponding to a Service Pack). | MSQDBVER | INT4 | 4 | ||
| PRODLEVEL | Date the executable sqlservr.exe was created. | MSQSSBLDDT | CHAR | 12 | ||
| SQLSTARTTM | Date and time of last SQL Server start. | MSQDBUPTME | CHAR | 20 | ||
| SQLEE | SQL Server edition: 'X' = Enterprise Ed., 'C' Cluster in use | MSQSSSQLEE | CHAR | 1 | ||
| NTVER | OS edition: A=Advanced Server, S=Server, D=Datacenter. | MSQSSNTEE | CHAR | 1 | ||
| PARAMDIFF | Single-Character Flag | CHAR1 | CHAR | 1 | ||
| DISKPERF | Single-Character Flag | CHAR1 | CHAR | 1 | ||
| ISCLUSTER | Is SQL Server clustered 'Y' or 'N' | MSSISCLUSTER | CHAR | 1 | ||
| IS3GB | Is SQL Server on machine with /3GB switch on 'Y' or 'N' | MSSIS3GB | CHAR | 1 | ||
| ISPAE | Is SQL Server on machine with PAE 'Y' or 'N' | MSSISPAE | CHAR | 1 | ||
| ISAWE | Is SQL Server AWE enabled Y' or 'N' | MSSISAWE | CHAR | 1 | ||
| CHIP | Processor type being used on the host running SQL Server. | MSQSSCHIP | CHAR | 20 | ||
| WINVER | Operating system version running on SQL Server host. | MSQSSWVER | CHAR | 80 | ||
| NUMCPUS | Number of CPUs on the host which runs SQL Server. | MSQSSCPUS | INT4 | 4 | ||
| SQLCPUS | Maximum number of CPUs SQL Server is configured to use. | MSQSQLCPUS | INT4 | 4 | ||
| MASK | Bitmask representing the CPUs available to Windows. | MSQSSMASK | CHAR | 8 | ||
| PHYMEM | Amount of RAM on the server running SQL Server | MSQSSRAM | INT4 | 4 | ||
| TRACEFLAGS | Trace flags which are currently set for SQL Server. | MSQSSTFLG | CHAR | 255 | ||
| MEMSETTING | Specifies how SQL Server memory parameters have been set | MSQMEMSET | CHAR | 10 | ||
| AGTLOGLOC | UNC path to a file used by SQL Server | MSSPATH | CHAR | 255 | ||
| ERRLOGLOC | UNC path to a file used by SQL Server | MSSPATH | CHAR | 255 | ||
| .INCLUDE | MSS_PMEM | 0 | ||||
| CONNECTMEM | Amount of dynamic memory the server is using for connections | MSSPMCONN | DEC | 12 | ||
| WRKPROCMEM | Amount of memory granted to executing processes in KB | MSSPMGWSPM | DEC | 12 | ||
| LOCKMEMORY | Amount of dynamic memory used for locks in KB | MSSPMLCKM | DEC | 12 | ||
| MAXWSPMEM | Maximum amount of memory available for executing SQL process | MSSPMMWSPM | DEC | 12 | ||
| OPTQRYMEM | Amount of memory SQL Server is using for query optimization | MSSPMOPMEM | DEC | 12 | ||
| SQLCACMEM | Amount of memory being used for dynamic SQL cache in KB | MSSPMCACM | DEC | 12 | ||
| TARSRVMEM | Amount of memory SQL Server is willing to consume in KB | MSSPMTARSM | DEC | 12 | ||
| TTLSRVMEM | Amount of memory SQL Server is currently using in KB. | MSSPMTTLSM | DEC | 12 | ||
| USERCONCTS | Number of user connections to the SQL Server system | MSSPSUSCON | DEC | 12 | ||
| CACHEHIT | Percentage of pages found in the buffer cache | MSSPBCACHT | DEC | 7 | ||
| DATACACHSZ | Size in KB of the data cache, including unused space | MSSPBDATAC | DEC | 12 | ||
| CACHESIZE | Size in KB of the procedure cache, including unused space. | MSSPBCACSZ | DEC | 12 | ||
| BUFFCOMMIT | Number of committed pages in cache. | MSSPBCOMIT | DEC | 12 | ||
| FREEBUFFER | Number of free pages available in cache. | MSSPBFREBF | DEC | 12 | ||
| STLPAGECNT | Number of buffer pages taken for other memory requirements | MSSPBSTPCT | DEC | 12 | ||
| .INCLUDE | MSS_PACCES | 0 | ||||
| FULLSCANS | Number of unrestricted base table or index scans | MSSPAFULLS | DEC | 12 | ||
| INDEXSRCH | Number of index searches | MSSPAIDXSR | DEC | 12 | ||
| EXTALLOCS | Number of extents allocated to database objects | MSSPAEXAL | DEC | 12 | ||
| EXTDEALLS | Number of extents deallocated in a database | MSSPAEXDE | DEC | 12 | ||
| PAGEALLOCS | Number of pages allocated to database objects | MSSPAPGAL | DEC | 12 | ||
| PAGEDEALLS | Number of pages deallocated in a database | MSSPAPGDE | DEC | 12 | ||
| PAGESPLITS | Number of index page splits in a database | MSSPAPGSPL | DEC | 12 | ||
| PROBESCANS | Number of probe scans in a database | MSSPAPRBSN | DEC | 12 | ||
| RANGESCANS | Number of range scans through indexes | MSSPARNGSN | DEC | 12 | ||
| WORKFILES | Number of work files created | MSSPAWFCRE | DEC | 12 | ||
| WORKTABLES | Number of work tables created | MSSPAWTCRE | DEC | 12 | ||
| LAZYWRITES | Number of pages written by the lazy writer to disk. | MSSPBLZWTS | DEC | 12 | ||
| PAGEREADS | Number of physical page reads | MSSPBPGRDS | DEC | 12 | ||
| PAGEWRITES | Number of physical page writes | MSSPBPGWRT | DEC | 12 | ||
| REQBUFFPG | Number of requests to find a page in the buffer pool. | MSSPBUFREQ | DEC | 12 | ||
| READAHEAD | Number of pages read in anticipation of use. | MSSPBRAPGS | DEC | 12 | ||
| AUTOPARAM | Number of auto-parameterization attempts | MSSPSAUTO | DEC | 12 | ||
| SQLBATCHS | Number of SQL batch requests received by server. | MSSPSBATCH | DEC | 12 | ||
| SQLCOMPILE | Number of SQL compilations | MSSPSQLCMP | DEC | 12 | ||
| AVGLTCHWT | Average wait time in ms for latch requests that waited. | MSSPSALTWT | DEC | 12 | ||
| LATCHWAITS | Number of latch requests that had to wait before granted. | MSSPSLTHWT | DEC | 12 | ||
| .INCLUDE | MSSDBSIZEINFO | 0 | ||||
| DB_SIZE | Database size in MB | MSS_DBSIZE | DEC | 8 | ||
| DB_ALLOC | Allocated space in database in MB | MSS_DBALLOC | DEC | 8 | ||
| LOG_SIZE | Log size in MB | MSS_LOGSIZE | DEC | 8 | ||
| LOG_ALLOC | Allocated space in log in MB | MSS_LOGALLOC | DEC | 8 | ||
| .INCLUDE | MSSTOTTABSIZEINFO | 0 | ||||
| RESERVED | Reserved size in KB | MSSRESSIZE | DEC | 8 | ||
| NUMTABS | Number of user tables | MSSNUMTABLES | INT4 | 4 | ||
| TABDATA | Data size in KB | MSSDATASIZE | DEC | 8 | ||
| NUMINDS | Number of indexes of user tables | MSSNUMINDEXES | INT4 | 4 | ||
| INDDATA | Index size in KB | MSSINDEXSIZE | DEC | 8 | ||
| UNUSED | Unused size in KB | MSSUNUSEDSIZE | DEC | 8 | ||
| NUMPROCS | Number of stored procedures created in DBI | MSSNUMPROCS | INT4 | 4 | ||
| .INCLUDE | MSQ_DYSERV | 0 | ||||
| SQLUPTIME | Number of seconds SQL Server has been running. | MSQDSSQLSC | INT4 | 4 | ||
| CPUBUSY | Number of seconds CPUs have been busy (sum for all CPUs) . | MSQDSCPUBY | INT4 | 4 | ||
| CPUIDLE | Number of seconds CPUs have been idle (sum for all CPUs) . | MSQDSCPUID | INT4 | 4 | ||
| IOBUSY | Number of seconds SQL Server tasks were busy with IO. | MSQDSIOBSY | INT4 | 4 | ||
| PCTCPU | Percent of time the CPUs have been busy. | MSQDSCPPCT | INT4 | 4 | ||
| PCTIDLE | Percent of time CPUs have been idle. | MSQDSIDPCT | INT4 | 4 | ||
| PCTIO | Percent of time SQL Server tasks have beeen busy whit IO. | MSQDSIOPCT | INT4 | 4 | ||
| PACKRECD | Number of network packets received. | MSQDSPCKRD | INT4 | 4 | ||
| PACKSENT | Number of network packets sent out by SQL Server. | MSQDSPCKST | INT4 | 4 | ||
| CONNECTS | Number of attempted connections to SQL Server. | MSQDSCONN | INT4 | 4 | ||
| PACKERRORS | Number of network packets with error since SQL Server start. | MSQDSPCKER | INT4 | 4 | ||
| TOTALREAD | Number of disk reads done by SQL Server (physical reads). | MSQDSTOTRD | INT4 | 4 | ||
| TOTALWRITE | Number of physical disk writes done by SQL Server. | MSQDSTOTWR | INT4 | 4 | ||
| TOTALERROR | Number of disk read or write errors since SQL Server started | MSQDSTOTER | INT4 | 4 | ||
| .INCLUDE | MSS_PFCACH | 0 | ||||
| CACHETYPE | Type of object in SQL Server procedure cache. | MSSPCTYPE | CHAR | 40 | ||
| HITRATIO | Procedure cache hit ratio as percentage. | MSSPCRATIO | DEC | 7 | ||
| OBJECTCNT | Number of objects stored in the procedure cache. | MSSPCOBJCT | DEC | 12 | ||
| OBJPAGES | Number of pages used by this object type in the cache. | MSSPCPAGES | DEC | 12 | ||
| USECOUNTS | Number of times an object of this type has been used. | MSSPCUSECT | DEC | 12 | ||
| R3USERS | Number of connections to SAP database from SAP application. | MSQDBSAPPC | INT4 | 4 | ||
| OTHERUSER | Number of non-SAP processes connected to SAP database. | MSQDBNUMPC | INT4 | 4 | ||
| UNIUSER | Number of different users connected to SAP database | MSQDBNDUSR | INT4 | 4 |