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