| RECORDDATE |
✔ |
Date |
DATUM |
DATS |
8 |
|
| RECORDTIME |
✔ |
Time |
UZEIT |
TIMS |
6 |
|
| ELAPSEDSEC |
|
MS SQL Server number of seconds elapsed since DB startup |
MSSELAPSED |
INT4 |
10 |
|
| 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 |
10 |
|
| 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 Indicator |
CHAR1 |
CHAR |
1 |
|
| DISKPERF |
|
Single-Character Indicator |
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 |
10 |
|
| SQLCPUS |
|
Maximum number of CPUs SQL Server is configured to use. |
MSQSQLCPUS |
INT4 |
10 |
|
| MASK |
|
Bitmask representing the CPUs available to Windows. |
MSQSSMASK |
CHAR |
8 |
|
| PHYMEM |
|
Amount of RAM on the server running SQL Server |
MSQSSRAM |
INT4 |
10 |
|
| 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 |
|
| CONNECTMEM |
|
Amount of dynamic memory the server is using for connections |
MSSPMCONN |
DEC |
23 |
|
| WRKPROCMEM |
|
Amount of memory granted to executing processes in KB |
MSSPMGWSPM |
DEC |
23 |
|
| LOCKMEMORY |
|
Amount of dynamic memory used for locks in KB |
MSSPMLCKM |
DEC |
23 |
|
| MAXWSPMEM |
|
Maximum amount of memory available for executing SQL process |
MSSPMMWSPM |
DEC |
23 |
|
| OPTQRYMEM |
|
Amount of memory SQL Server is using for query optimization |
MSSPMOPMEM |
DEC |
23 |
|
| SQLCACMEM |
|
Amount of memory being used for dynamic SQL cache in KB |
MSSPMCACM |
DEC |
23 |
|
| TARSRVMEM |
|
Amount of memory SQL Server is willing to consume in KB |
MSSPMTARSM |
DEC |
23 |
|
| TTLSRVMEM |
|
Amount of memory SQL Server is currently using in KB. |
MSSPMTTLSM |
DEC |
23 |
|
| USERCONCTS |
|
Number of user connections to the SQL Server system |
MSSPSUSCON |
DEC |
23 |
|
| CACHEHIT |
|
Percentage of pages found in the buffer cache |
MSSPBCACHT |
DEC |
13 |
|
| DATACACHSZ |
|
Size in KB of the data cache, including unused space |
MSSPBDATAC |
DEC |
23 |
|
| CACHESIZE |
|
Size in KB of the procedure cache, including unused space. |
MSSPBCACSZ |
DEC |
23 |
|
| BUFFCOMMIT |
|
Number of committed pages in cache. |
MSSPBCOMIT |
DEC |
23 |
|
| FREEBUFFER |
|
Number of free pages available in cache. |
MSSPBFREBF |
DEC |
23 |
|
| STLPAGECNT |
|
Number of buffer pages taken for other memory requirements |
MSSPBSTPCT |
DEC |
23 |
|
| FULLSCANS |
|
Number of unrestricted base table or index scans |
MSSPAFULLS |
DEC |
23 |
|
| INDEXSRCH |
|
Number of index searches |
MSSPAIDXSR |
DEC |
23 |
|
| EXTALLOCS |
|
Number of extents allocated to database objects |
MSSPAEXAL |
DEC |
23 |
|
| EXTDEALLS |
|
Number of extents deallocated in a database |
MSSPAEXDE |
DEC |
23 |
|
| PAGEALLOCS |
|
Number of pages allocated to database objects |
MSSPAPGAL |
DEC |
23 |
|
| PAGEDEALLS |
|
Number of pages deallocated in a database |
MSSPAPGDE |
DEC |
23 |
|
| PAGESPLITS |
|
Number of index page splits in a database |
MSSPAPGSPL |
DEC |
23 |
|
| PROBESCANS |
|
Number of probe scans in a database |
MSSPAPRBSN |
DEC |
23 |
|
| RANGESCANS |
|
Number of range scans through indexes |
MSSPARNGSN |
DEC |
23 |
|
| WORKFILES |
|
Number of work files created |
MSSPAWFCRE |
DEC |
23 |
|
| WORKTABLES |
|
Number of work tables created |
MSSPAWTCRE |
DEC |
23 |
|
| LAZYWRITES |
|
Number of pages written by the lazy writer to disk. |
MSSPBLZWTS |
DEC |
23 |
|
| PAGEREADS |
|
Number of physical page reads |
MSSPBPGRDS |
DEC |
23 |
|
| PAGEWRITES |
|
Number of physical page writes |
MSSPBPGWRT |
DEC |
23 |
|
| REQBUFFPG |
|
Number of requests to find a page in the buffer pool. |
MSSPBUFREQ |
DEC |
23 |
|
| READAHEAD |
|
Number of pages read in anticipation of use. |
MSSPBRAPGS |
DEC |
23 |
|
| AUTOPARAM |
|
Number of auto-parameterization attempts |
MSSPSAUTO |
DEC |
23 |
|
| SQLBATCHS |
|
Number of SQL batch requests received by server. |
MSSPSBATCH |
DEC |
23 |
|
| SQLCOMPILE |
|
Number of SQL compilations |
MSSPSQLCMP |
DEC |
23 |
|
| AVGLTCHWT |
|
Average wait time in ms for latch requests that waited. |
MSSPSALTWT |
DEC |
23 |
|
| LATCHWAITS |
|
Number of latch requests that had to wait before granted. |
MSSPSLTHWT |
DEC |
23 |
|
| DB_SIZE |
|
Database size in MB |
MSS_DBSIZE |
DEC |
15 |
|
| DB_ALLOC |
|
Allocated space in database in MB |
MSS_DBALLOC |
DEC |
15 |
|
| LOG_SIZE |
|
Log size in MB |
MSS_LOGSIZE |
DEC |
15 |
|
| LOG_ALLOC |
|
Allocated space in log in MB |
MSS_LOGALLOC |
DEC |
15 |
|
| RESERVED |
|
Reserved size in KB |
MSSRESSIZE |
DEC |
15 |
|
| NUMTABS |
|
Number of user tables |
MSSNUMTABLES |
INT4 |
10 |
|
| TABDATA |
|
Data size in KB |
MSSDATASIZE |
DEC |
15 |
|
| NUMINDS |
|
Number of indexes of user tables |
MSSNUMINDEXES |
INT4 |
10 |
|
| INDDATA |
|
Index size in KB |
MSSINDEXSIZE |
DEC |
15 |
|
| UNUSED |
|
Unused size in KB |
MSSUNUSEDSIZE |
DEC |
15 |
|
| NUMPROCS |
|
Number of stored procedures created in DBI |
MSSNUMPROCS |
INT4 |
10 |
|
| SQLUPTIME |
|
Number of seconds SQL Server has been running. |
MSQDSSQLSC |
INT4 |
10 |
|
| CPUBUSY |
|
Number of seconds CPUs have been busy (sum for all CPUs) . |
MSQDSCPUBY |
INT4 |
10 |
|
| CPUIDLE |
|
Number of seconds CPUs have been idle (sum for all CPUs) . |
MSQDSCPUID |
INT4 |
10 |
|
| IOBUSY |
|
Number of seconds SQL Server tasks were busy with IO. |
MSQDSIOBSY |
INT4 |
10 |
|
| PCTCPU |
|
Percent of time the CPUs have been busy. |
MSQDSCPPCT |
INT4 |
10 |
|
| PCTIDLE |
|
Percent of time CPUs have been idle. |
MSQDSIDPCT |
INT4 |
10 |
|
| PCTIO |
|
Percent of time SQL Server tasks have beeen busy whit IO. |
MSQDSIOPCT |
INT4 |
10 |
|
| PACKRECD |
|
Number of network packets received. |
MSQDSPCKRD |
INT4 |
10 |
|
| PACKSENT |
|
Number of network packets sent out by SQL Server. |
MSQDSPCKST |
INT4 |
10 |
|
| CONNECTS |
|
Number of attempted connections to SQL Server. |
MSQDSCONN |
INT4 |
10 |
|
| PACKERRORS |
|
Number of network packets with error since SQL Server start. |
MSQDSPCKER |
INT4 |
10 |
|
| TOTALREAD |
|
Number of disk reads done by SQL Server (physical reads). |
MSQDSTOTRD |
INT4 |
10 |
|
| TOTALWRITE |
|
Number of physical disk writes done by SQL Server. |
MSQDSTOTWR |
INT4 |
10 |
|
| TOTALERROR |
|
Number of disk read or write errors since SQL Server started |
MSQDSTOTER |
INT4 |
10 |
|
| CACHETYPE |
|
Type of object in SQL Server procedure cache. |
MSSPCTYPE |
CHAR |
40 |
|
| HITRATIO |
|
Procedure cache hit ratio as percentage. |
MSSPCRATIO |
DEC |
13 |
|
| OBJECTCNT |
|
Number of objects stored in the procedure cache. |
MSSPCOBJCT |
DEC |
23 |
|
| OBJPAGES |
|
Number of pages used by this object type in the cache. |
MSSPCPAGES |
DEC |
23 |
|
| USECOUNTS |
|
Number of times an object of this type has been used. |
MSSPCUSECT |
DEC |
23 |
|
| R3USERS |
|
Number of connections to SAP database from SAP application. |
MSQDBSAPPC |
INT4 |
10 |
|
| OTHERUSER |
|
Number of non-SAP processes connected to SAP database. |
MSQDBNUMPC |
INT4 |
10 |
|
| UNIUSER |
|
Number of different users connected to SAP database |
MSQDBNDUSR |
INT4 |
10 |
|
